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_BALANCE_CLASSIFICATIONS

Line 175: FROM hr_s_balance_classifications pbc

171: WHERE legislation_code = 'ZZ';
172:
173: CURSOR get_balance_class_csr IS
174: SELECT distinct pbc.balance_classification_id, pbt.balance_name bname
175: FROM hr_s_balance_classifications pbc
176: ,hr_s_balance_types pbt
177: WHERE pbc.legislation_code ='ZZ'
178: AND pbc.balance_type_id = pbt.balance_type_id;
179:

Line 241: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Classifications', 'HR_S_BALANCE_CLASSIFICATIONS');

237: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Legislation Rule', rec.rule_type);
238: END LOOP;
239:
240: write_log('OUTPUT',NULL,NULL,NULL);
241: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Classifications', 'HR_S_BALANCE_CLASSIFICATIONS');
242:
243: FOR rec IN get_balance_class_csr LOOP
244: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Balance Classification for balance', rec.bname);
245: END LOOP;

Line 494: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_CLASSIFICATIONS',NULL);

490: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_TYPES',NULL);
491: DELETE hr_s_balance_types;
492: COMMIT;
493:
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);

Line 495: DELETE hr_s_balance_classifications;

491: DELETE hr_s_balance_types;
492: COMMIT;
493:
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;

Line 1313: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Classifications', 'HR_S_BALANCE_CLASSIFICATIONS');

1309:
1310: --Balance Classifications
1311:
1312: write_log('LOG',NULL,NULL,NULL);
1313: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Classifications', 'HR_S_BALANCE_CLASSIFICATIONS');
1314: FOR rec IN get_balance_class_csr LOOP
1315: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Classifications', rec.balance_classification_id);
1316:
1317: INSERT INTO hr_s_balance_classifications

Line 1317: INSERT INTO hr_s_balance_classifications

1313: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Balance Classifications', 'HR_S_BALANCE_CLASSIFICATIONS');
1314: FOR rec IN get_balance_class_csr LOOP
1315: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Balance Classifications', rec.balance_classification_id);
1316:
1317: INSERT INTO hr_s_balance_classifications
1318: ( balance_classification_id
1319: ,business_group_id
1320: ,legislation_code
1321: ,balance_type_id

Line 1855: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_CLASSIFICATIONS',NULL);

1851: WHERE legislation_code = 'ZZ';
1852:
1853: --Updating Balance Classifications
1854:
1855: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_CLASSIFICATIONS',NULL);
1856: UPDATE hr_s_balance_classifications
1857: SET legislation_code = p_legislation_code
1858: WHERE legislation_code = 'ZZ';
1859:

Line 1856: UPDATE hr_s_balance_classifications

1852:
1853: --Updating Balance Classifications
1854:
1855: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_BALANCE_CLASSIFICATIONS',NULL);
1856: UPDATE hr_s_balance_classifications
1857: SET legislation_code = p_legislation_code
1858: WHERE legislation_code = 'ZZ';
1859:
1860: --Updating Report Format Mapping