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 108: FROM hr_s_defined_balances pdb

104: (b.status in ('I', 'S') AND c.application_short_name = 'PQP'));
105:
106: CURSOR get_defined_balances_csr IS
107: SELECT distinct defined_balance_id, pbt.balance_name bname
108: FROM hr_s_defined_balances pdb
109: ,hr_s_balance_types pbt
110: ,hr_s_application_ownerships ao
111: ,fnd_product_installations b
112: ,fnd_application c

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

192:
193: -- write output file for Defined Balance to be Installed.
194:
195: write_log('OUTPUT',NULL,NULL,NULL);
196: --write_log ('OUTPUT','PAY_34011_IP_INS_DATA_IN_TABLE', 'Defined Balances', 'HR_S_DEFINED_BALANCES');
197:
198: FOR rec IN get_defined_balances_csr LOOP
199: write_log ('OUTPUT','PAY_34012_IP_INS_DATA', 'Defined Balances for Balance Type', rec.bname);
200: END LOOP;

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

436: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_CLASSIFICATIONS',NULL);
437: DELETE hr_s_balance_classifications;
438: COMMIT;
439:
440: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DEFINED_BALANCES',NULL);
441: DELETE hr_s_defined_balances;
442: COMMIT;
443:
444: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_FEEDS_F',NULL);

Line 441: DELETE hr_s_defined_balances;

437: DELETE hr_s_balance_classifications;
438: COMMIT;
439:
440: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_DEFINED_BALANCES',NULL);
441: DELETE hr_s_defined_balances;
442: COMMIT;
443:
444: write_log('LOG','PAY_34000_IP_TRUNCATE_TABLES','HR_S_BALANCE_FEEDS_F',NULL);
445: DELETE hr_s_balance_feeds_f;

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

908: hr_utility.set_location('pay_ip_startup_util.move_to_shadow_tables ',30);
909:
910: --Defined Balance
911: write_log('LOG',NULL,NULL,NULL);
912: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Defined Balances', 'HR_S_DEFINED_BALANCES');
913: FOR rec IN get_defined_balances_csr LOOP
914: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Defined Balances for Balance Type', rec.bname);
915: INSERT INTO hr_s_defined_balances
916: ( defined_balance_id

Line 915: INSERT INTO hr_s_defined_balances

911: write_log('LOG',NULL,NULL,NULL);
912: write_log ('LOG','PAY_34011_IP_INS_DATA_IN_TABLE', 'Defined Balances', 'HR_S_DEFINED_BALANCES');
913: FOR rec IN get_defined_balances_csr LOOP
914: write_log ('LOG','PAY_34012_IP_INS_DATA', 'Defined Balances for Balance Type', rec.bname);
915: INSERT INTO hr_s_defined_balances
916: ( defined_balance_id
917: ,business_group_id
918: ,legislation_code
919: ,balance_type_id

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

1451: WHERE legislation_code = 'ZZ';
1452:
1453: --Updating Defined Balances Table
1454:
1455: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_DEFINED_BALANCES',NULL);
1456: UPDATE hr_s_defined_balances
1457: SET legislation_code = p_legislation_code
1458: WHERE legislation_code = 'ZZ';
1459:

Line 1456: UPDATE hr_s_defined_balances

1452:
1453: --Updating Defined Balances Table
1454:
1455: write_log('LOG','PAY_34015_IP_UPD_TABLE','HR_S_DEFINED_BALANCES',NULL);
1456: UPDATE hr_s_defined_balances
1457: SET legislation_code = p_legislation_code
1458: WHERE legislation_code = 'ZZ';
1459:
1460: