m2u-upass-admin / DBScript / insert_ib_payee.sql @ 18:f6f916c1b907
History | View | Annotate | Download (57.3 KB)
1 | 0:ea666cc7880e | hadi | Rem ===================================================================== |
---|---|---|---|
2 | Rem NAME |
||
3 | Rem <insert_ib_payee.sql> |
||
4 | Rem DESCRIPTION |
||
5 | Rem <Insert Data into IB_PAYEE Table> |
||
6 | Rem MODULE |
||
7 | Rem <Authentication Module> |
||
8 | Rem MODIFIED (MM/DD/YYYY) |
||
9 | Rem Shuhaida 17/03/2011 - Creation |
||
10 | Rem xxxxxx mm/dd/yyyy - Modify |
||
11 | Rem ===================================================================== |
||
12 | |||
13 | SET DEFINE OFF;
|
||
14 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (2,25,'0032','ALLIED BANK OR PNB CREDIT CARDS','ALLIED BANK OR PNB CC','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'1','1','Account / Reference Number',null,null,null,'0','1',to_timestamp('19-JAN-11 07.45.44.320000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAR-11 01.57.31.070000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
15 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (3,23,'0084','DESTINY CABLE INC.','DESTINY CABLE INC.','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account / Reference Number',null,null,null,'0','1',to_timestamp('19-JAN-11 07.47.59.420000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 04.25.01.540000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
16 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (5,25,'0015','BANCO FILIPINO VISA','BANCO FILIPINO VISA','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'1','1',to_timestamp('19-JAN-11 07.50.37.990000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAR-11 01.59.59.110000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
17 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (6,25,'0090','BANKCARD INC.','BANKCARD INC.','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('19-JAN-11 07.51.33.500000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 04.27.01.330000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
18 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (8,24,'0022','SSS CONTRIBUTIONS','SSS CONTRIBUTIONS','0','1','1',null,'1',null,'1','1','1',0,'1',0,null,'1','1',null,null,null,null,'1','1',to_timestamp('19-JAN-11 07.52.15.740000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAR-11 01.59.38.330000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
19 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (9,25,'0061','BDO CREDIT CARD','BDO CREDIT CARD','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('19-JAN-11 07.52.18.350000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 11.43.47.110000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
20 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (10,25,'0037','CHINATRUST VISA CARDS','CHINATRUST VISA CARDS','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'1','1',to_timestamp('19-JAN-11 07.53.37.390000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAR-11 02.00.35.720000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
21 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (11,25,'0050','CITIBANK VISA or MC','CITIBANK VISA or MC','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account / Reference Number',null,null,null,'0','1',to_timestamp('19-JAN-11 07.55.50.990000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-MAR-11 04.54.01.080000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
22 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (12,24,'0076','SSS CONTRIBUTIONS FARMERS AND FISHERMENS','SSS FARMERS FISHERMAN','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','0','Account/Reference Number',null,null,null,'0','1',to_timestamp('19-JAN-11 07.56.29.550000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAR-11 11.28.57.780000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
23 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (13,25,'0033','EASTWEST CARD_Philam AIG CARD','EASTWEST CARD_Philam AIG CARD','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1',null,null,null,null,'0','1',to_timestamp('19-JAN-11 07.56.35.140000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 06.45.04.200000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
24 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (14,25,'0035','HSBC CARDS','HSBC CARDS','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('19-JAN-11 07.57.18.260000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-FEB-11 08.34.13.800000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
25 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (16,25,'0005','STANDARD CHARTERED VISA or MC','STANDARD CHARTERED VISA or MC','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 09.14.38.870000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 11.27.29.400000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
26 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (19,23,'0081','SKY CABLE','SKY CABLE','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 09.52.44.980000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 04.25.31.780000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
27 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (20,25,'0014','SB CARD DINERS or SBC MC','SB CARD DINERS or SBC MC','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 10.09.40.420000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 07.10.12.140000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
28 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (21,25,'0087','UNION BANK VISA CARD','UNION BANK VISA CARD','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 10.10.46.500000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 04.26.23.630000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
29 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (22,24,'0077','SSS CONTRIBUTIONS OFW','SSS CONTRIBUTIONS OFW','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','0','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 10.28.26.900000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAR-11 11.29.38.120000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
30 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (23,24,'0074','SSS CONTRIBUTIONS SELF EMPLOYED','SSS CONTRIBUTIONS SELF EMPLOYD','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 10.29.10.990000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAR-11 10.54.48.340000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
31 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (24,24,'0075','SSS CONTRIBUTIONS VOLUNTARY MEMBERS','SSS CONTRIBUTIONS MEMBERS','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 10.32.52.270000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAR-11 10.55.08.750000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
32 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (25,26,'0096','BANTAY BATA','BANTAY BATA','0','1','1',null,'1',null,'1','0','1',0,'1',0,null,'1','1',null,null,null,null,'1','1',to_timestamp('21-JAN-11 10.51.42.030000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-MAR-11 11.13.59.370000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
33 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (26,26,'0097','CHURCH OF JESUS CHRIST OF LATTER DAY','CHURCH OF JESUS CHRIST ','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 10.52.32.260000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 04.19.00.560000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
34 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (27,26,'0051','FAR EAST BROADCASTING','FAR EAST BROADCASTING','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 10.53.59.170000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 05.29.34.190000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
35 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (28,26,'0094','KNOWLEDGE CHANNEL','KNOWLEDGE CHANNEL','0','1','1',null,'1',null,'1','0','1',0,'1',0,null,'1','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 10.55.40.420000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-MAR-11 09.09.22.090000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
36 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (29,26,'0101','OPERATION SMILE','OPERATION SMILE','0','1','1',null,'1',null,'1','0','1',0,'1',0,null,'1','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 10.55.59.960000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-MAR-11 09.08.51.680000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
37 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (30,26,'0095','PISO PARA SA PASIG','PISO PARA SA PASIG','0','1','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'1','1',to_timestamp('21-JAN-11 10.56.17.050000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-MAR-11 11.14.21.080000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
38 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (31,26,'0092','RESOURCES FOR THE BLIND','RESOURCES FOR THE BLIND','0','1','1',null,'1',null,'1','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 10.56.42.840000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-MAR-11 07.29.45.460000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
39 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (32,26,'0091','WORLD VISION','WORLD VISION','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 10.57.06.870000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 04.20.20.460000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
40 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (33,27,'0068','FORTUNE LIFE INSURANCE CO INC','FORTUNE LIFE INSURANCE CO INC','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 10.58.21.630000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 05.26.09.280000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
41 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (34,27,'0052','FORTUNE MEDICARE','FORTUNE MEDICARE','0','0','1',null,'1',null,'1','1','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 10.58.41.390000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAR-11 01.43.21.660000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
42 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (35,27,'0041','GREAT LIFE FINANCIAL','FORTUNE MEDICARE','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 10.58.55.350000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 05.28.16.460000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
43 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (36,27,'0003','GREPALIFE','GREPALIFE','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 10.59.30.890000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 05.28.37.970000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
44 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (37,27,'0039','MANILA MEMORIAL','MANILA MEMORIAL','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 10.59.52.090000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 05.28.53.150000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
45 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (38,27,'0064','PARAMOUNT LIFE','PARAMOUNT LIFE','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.00.19.910000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 05.29.18.550000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
46 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (40,27,'0042','PIONEER LIFE INC','PIONEER LIFE INC','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.01.43.630000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 05.29.49.560000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
47 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (41,27,'0086','PNB LIFE INSURANCE','PNB LIFE INSURANCE','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'1','1',to_timestamp('21-JAN-11 11.02.24.400000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAR-11 01.59.19.750000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
48 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (42,27,'0036','PRUDENTIAL LIFE PLANS','PRUDENTIAL LIFE PLANS','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.02.49.520000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 05.30.19.800000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
49 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (43,27,'0011','PRULIFE UK INSURANCE','PRULIFE UK INSURANCE','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.03.21.130000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 07.00.49.080000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
50 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (44,27,'0066','SUNLIFE OF CANADA PHILS','SUNLIFE OF CANADA PHILS','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.03.48.610000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 05.30.54.510000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
51 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (45,34,'0056','MANILA WATER','MANILA WATER','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.06.28.610000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 03.15.16.940000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
52 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (46,34,'0060','MAYNILAD WATER SERVICES INC','MAYNILAD WATER SERVICES INC','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.06.53.620000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 02.32.08.600000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
53 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (47,34,'0040','MERALCO','MERALCO','0','0','1',null,'1',null,'1','1','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.07.12.900000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAR-11 01.43.01.600000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
54 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (48,34,'0012','PRIMEWATER','PRIMEWATER','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.07.31.370000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-MAR-11 02.26.07.430000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
55 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (49,34,'0048','SUBIC WATER AND SEWERAGE CO INC','SUBIC WATER','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.08.19.380000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 10.22.45.930000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
56 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (50,34,'0085','VISAYAN ELECTRIC COMPANY CORP','VISAYAN ELECTRIC COMPANY CORP','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.09.00.030000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 04.24.15.960000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
57 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (51,29,'0009','IPM REALTY AND DEVT CORP','IPM REALTY AND DEVT CORP','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.09.48.100000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 06.55.18.780000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
58 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (52,29,'0028','ROCKWELL RESIDENTIAL TOWERS','ROCKWELL RESIDENTIAL TOWERS','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.10.09.850000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 06.56.18.600000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
59 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (53,32,'0044','DON BOSCO TECHNOLOGY CENTER','DON BOSCO TECHNOLOGY CENTER','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.10.54.550000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 11.33.29.080000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
60 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (54,32,'0007','LA SALLE GREENHILLS','LA SALLE GREENHILLS','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.11.23.460000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 06.51.59.820000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
61 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (55,32,'0055','MIRIAM COLLEGE','MIRIAM COLLEGE','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.11.47.330000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 03.14.55.720000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
62 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (56,32,'0024','UNIVERSITY OF SAN JOSE RECOLETOS','UNIV OF SAN JOSE RECOLETOS','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.13.12.970000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 07.23.54.090000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
63 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (57,31,'0073','MY DESTINY SBC','MY DESTINY SBC','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.17.22.270000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 04.27.43.940000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
64 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (58,31,'0034','DIGITEL','DIGITEL','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.17.47.350000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 06.47.45.180000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
65 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (59,31,'0046','EASTERN TELECOM','EASTERN TELECOM','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.18.14.340000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-FEB-11 11.29.12.610000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
66 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (60,31,'0031','GLOBE TELECOMS','GLOBE TELECOMS','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.18.53.380000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 06.38.34.400000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
67 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (61,31,'0025','ICC BAYANTEL','ICC BAYANTEL','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.19.19.460000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 07.25.33.990000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
68 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (63,31,'0021','INNOVE COMMUNICATIONS','INNOVE COMMUNICATIONS','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.19.58.050000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 07.13.13.220000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
69 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (64,31,'0078','PLDT','PLDT','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.20.11.940000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 04.23.20.070000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
70 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (66,31,'0023','SMART','SMART','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.21.04.190000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 07.17.54.090000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
71 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (101,26,'1111','GAWAD KALINGA','GAWAD KALINGA','0','1','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'1','1',to_timestamp('02-MAR-11 09.30.16.460000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-MAR-11 11.12.14.860000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
72 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (112,31,'0104','COSCOM','COSCOM','0','0','0','Account Refence Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('05-MAR-11 10.32.00.770000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-MAR-11 10.32.00.770000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
73 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (69,31,'0103','WI TRIBE PROPRIETARY CHANNELS','WI TRIBE','0','1','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.22.28.780000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAR-11 11.43.27.130000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
74 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (71,30,'0088','BRITISH EMBASSY','BRITISH EMBASSY','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.23.32.240000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 04.21.26.570000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
75 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (72,30,'0057','CDC MIMOSA',' CDC MIMOSA','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.23.56.070000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 05.31.37.870000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
76 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (74,30,'0049','DIRECTORIES PHILIPPINES CORPORATION','DIRECTORIES PHIL CORP','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.24.50.820000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 05.27.55.910000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
77 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (75,30,'0027','EASY TRIP','EASY TRIP','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.25.15.970000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 06.53.05.150000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
78 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (76,30,'0053','FG FINANCIAL CO INC','FG FINANCIAL CO INC','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.25.46.490000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 05.30.27.040000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
79 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (77,30,'0002','FIRST PEAK RESOURCES','FIRST PEAK RESOURCES','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.26.06.950000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 07.20.01.620000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
80 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (78,30,'0102','IOS MARKETING CORP','IOS MARKETING CORP','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.26.33.800000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-MAR-11 08.50.48.460000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
81 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (80,30,'0093','NSO HELPLINE PLUS','NSO HELPLINE PLUS','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.27.15.680000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 04.22.28.700000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
82 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (98,30,'0105','PHILAM ASSET MANAGEMENT INC.','PHILAM ASSET MANAGEMENT INC.','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account/Reference Number',null,null,null,'0','1',to_timestamp('28-FEB-11 07.14.47.210000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 10.56.52.560000000 AM','DD-MON-RR HH.MI.SS.FF AM')); |
||
83 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (82,30,'0008','US EMBASSY FEES','US EMBASSY FESS','0','0','1',null,'1',null,'1','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.28.10.080000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-MAR-11 12.14.14.130000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
84 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (83,28,'0069','CHINATRUST SALARY STRETCH','CHINATRUST SALARY STRETCH','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.29.07.530000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 05.33.38.870000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
85 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (84,28,'0072','CITIFINANCIAL','CITIFINANCIAL','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1','Account / Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.29.25.870000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-MAR-11 03.29.19.510000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
86 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (85,28,'0010','CITIBANK SAVINGS LOANS','CITIBANK SAVINGS LOANS','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.29.50.580000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 06.58.01.890000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
87 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (86,28,'0058','CITYSTATE BANK LOAN PAYMENTS','CITYSTATE BANK LOAN PAYMENTS','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.30.19.180000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 05.31.57.650000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
88 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (87,28,'0004','HSBC PERSONAL INSTALLMENT LOANS','HSBC PERSONAL INSTALLMENT LOAN','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.30.43.980000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 06.38.06.040000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
89 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (88,28,'0059','PS BANK LOANS','PS BANK LOANS','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.31.07.310000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 05.32.17.650000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
90 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (89,28,'0029','SCB EZ LOAN','SCB EZ LOAN','0','0','1',null,'1',null,'0','0','1',0,'1',0,null,'0','1',null,null,null,null,'0','1',to_timestamp('21-JAN-11 11.31.40.140000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 07.07.02.640000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
91 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (90,30,'0006','PAFP FAMILY PHYSICIANS','PAFP FAMILY PHYSICIANS','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','0','Account Reference Number',null,null,null,'0','1',to_timestamp('21-JAN-11 11.32.32.170000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-MAR-11 06.48.22.340000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
92 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (95,25,'0026','MBTC_PSB Card','MBTC_PSB Card','0','0','0','Account Reference Number','1',null,'0','0','1',0,'1',0,null,'0','1',null,null,null,null,'0','1',to_timestamp('25-FEB-11 03.23.10.330000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAR-11 09.39.33.260000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
93 | Insert into IB_PAYEE (OID,CONTENT_CATEGORY_ID,PAYEE_CODE,FULL_NAME,SHORT_NAME,ONLINE_PAYMENT,BILL_ACCT_REQ,ACCT_DISPLAY_NAME_REQ,BILL_ACCT_DISP_NAME,IMAGE_REQ,IMAGE_URL,FAV_REGISTER_INDI,EFFECTIVE_DATE,MIN_PAYMENT,MIN_PAYMENT_AMOUNT,MAX_PAYMENT,MAX_PAYMENT_AMOUNT,PAYMENT_TYPE,REF_NO_REQ,REF_NO_NAME_REQ,REF_NO_NAME_DISPLAY,NOTE1_REQUIRED,NOTE2_REQUIRED,NOTE3_REQUIRED,STATUS,DELETED,CREATION_DATE,LAST_MOD_DATE) values (96,33,'0043','CEBU PACIFIC','CEBU PACIFIC','0','0','1',null,'1',null,'1','1','1',0,'1',0,null,'1','1',null,null,null,null,'0','1',to_timestamp('28-FEB-11 01.03.10.870000000 PM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAR-11 01.46.36.700000000 PM','DD-MON-RR HH.MI.SS.FF AM')); |
||
94 | COMMIT; |