APPS.PAY_BALANCE_UPLOAD dependencies on PAY_LATEST_BALANCES

Line 98: pay_latest_balances table

94: Corrected validate_balance to use
95: element link validity cache.
96: 115.39 A.Logue 22-DEC-2003 Use of unsecured base tables for performance.
97: 115.38 T.Battoo 3-NOV-2003 support for sparse matrix and
98: pay_latest_balances table
99: 115.37 T.Habara 18-SEP-2003 Modified the BF include_adjustment call
100: to pass Source ID and Source Text values.
101: 115.36 N.Bristow 13-MAR-2003 Source ID and Source Text where being corrupted
102: on run results.

Line 3475: select pay_latest_balances_s.nextval

3471: fetch csr_get_def_bal into l_defined_bal;
3472: close csr_get_def_bal;
3473: --
3474: hr_utility.set_location('pay_balance_upload.ins_latest_balance',10);
3475: select pay_latest_balances_s.nextval
3476: into l_lat_bal_id
3477: from sys.dual;
3478: --
3479: -- get bus grp id

Line 3492: insert into pay_latest_balances

3488:
3489: if (l_status='Y')
3490: then
3491: hr_utility.trace('latest balances table');
3492: insert into pay_latest_balances
3493: (latest_balance_id,
3494: assignment_id,
3495: defined_balance_id,
3496: assignment_action_id,