eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IP_STARTUP_UTIL dependencies on HR_S_DEFINED_BALANCES

Line 114: FROM hr_s_defined_balances pdb

110: (b.status in ('I', 'S') AND c.application_short_name = 'PQP'));
111:
112: CURSOR get_defined_balances_csr IS
113: SELECT distinct defined_balance_id, pbt.balance_name bname
114: FROM hr_s_defined_balances pdb
115: ,hr_s_balance_types pbt
116: ,hr_s_application_ownerships ao
117: ,fnd_product_installations b
118: ,fnd_application c

Line 202: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Defined Balances', 'HR_S_DEFINED_BALANCES');

198:
199: -- write output file for Defined Balance to be Installed.
200:
201: write_log('OUTPUT',NULL,NULL,NULL);
202: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Defined Balances', 'HR_S_DEFINED_BALANCES');
203:
204: FOR rec IN get_defined_balances_csr LOOP
205: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Defined Balances for Balance Type', rec.bname);
206: END LOOP;

Line 498: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DEFINED_BALANCES',NULL);

494: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_CLASSIFICATIONS',NULL);
495: DELETE hr_s_balance_classifications;
496: COMMIT;
497:
498: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DEFINED_BALANCES',NULL);
499: DELETE hr_s_defined_balances;
500: COMMIT;
501:
502: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_FEEDS_F',NULL);

Line 499: DELETE hr_s_defined_balances;

495: DELETE hr_s_balance_classifications;
496: COMMIT;
497:
498: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DEFINED_BALANCES',NULL);
499: DELETE hr_s_defined_balances;
500: COMMIT;
501:
502: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_FEEDS_F',NULL);
503: DELETE hr_s_balance_feeds_f;

Line 1041: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Defined Balances', 'HR_S_DEFINED_BALANCES');

1037: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',30);
1038:
1039: --Defined Balance
1040: write_log('LOG',NULL,NULL,NULL);
1041: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Defined Balances', 'HR_S_DEFINED_BALANCES');
1042: FOR rec IN get_defined_balances_csr LOOP
1043: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Defined Balances for Balance Type', rec.bname);
1044: INSERT INTO hr_s_defined_balances
1045: ( defined_balance_id

Line 1044: INSERT INTO hr_s_defined_balances

1040: write_log('LOG',NULL,NULL,NULL);
1041: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Defined Balances', 'HR_S_DEFINED_BALANCES');
1042: FOR rec IN get_defined_balances_csr LOOP
1043: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Defined Balances for Balance Type', rec.bname);
1044: INSERT INTO hr_s_defined_balances
1045: ( defined_balance_id
1046: ,business_group_id
1047: ,legislation_code
1048: ,balance_type_id

Line 1826: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_DEFINED_BALANCES',NULL);

1822: WHERE legislation_code = 'ZZ';
1823:
1824: --Updating Defined Balances Table
1825:
1826: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_DEFINED_BALANCES',NULL);
1827: UPDATE hr_s_defined_balances
1828: SET legislation_code = p_legislation_code
1829: WHERE legislation_code = 'ZZ';
1830:

Line 1827: UPDATE hr_s_defined_balances

1823:
1824: --Updating Defined Balances Table
1825:
1826: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_DEFINED_BALANCES',NULL);
1827: UPDATE hr_s_defined_balances
1828: SET legislation_code = p_legislation_code
1829: WHERE legislation_code = 'ZZ';
1830:
1831: