APPS.PAY_BALANCE_UPLOAD dependencies on PAY_LATEST_BALANCES

Line 96: pay_latest_balances table

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

Line 3182: select pay_latest_balances_s.nextval

3178: fetch csr_get_def_bal into l_defined_bal;
3179: close csr_get_def_bal;
3180: --
3181: hr_utility.set_location('pay_balance_upload.ins_latest_balance',10);
3182: select pay_latest_balances_s.nextval
3183: into l_lat_bal_id
3184: from sys.dual;
3185: --
3186: -- get bus grp id

Line 3199: insert into pay_latest_balances

3195:
3196: if (l_status='Y')
3197: then
3198: hr_utility.trace('latest balances table');
3199: insert into pay_latest_balances
3200: (latest_balance_id,
3201: assignment_id,
3202: defined_balance_id,
3203: assignment_action_id,