APPS.GROSSUP_UPD dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

Line 57: FROM pay_assignment_latest_balances alb,

53: IS
54:
55: CURSOR get_latest_bal IS
56: SELECT latest_balance_id
57: FROM pay_assignment_latest_balances alb,
58: pay_defined_balances pdb
59: WHERE alb.latest_balance_id BETWEEN p_start_latest_bal_id
60: AND p_end_latest_bal_id
61: AND alb.defined_balance_id = pdb.defined_balance_id

Line 78: delete from pay_assignment_latest_balances

74:
75: --hr_utility.trace('Deleted context value '||latebal_rec.latest_balance_id);
76:
77: --
78: delete from pay_assignment_latest_balances
79: where latest_balance_id = latebal_rec.latest_balance_id;
80:
81: --hr_utility.trace('Deleted asg late bal '||latebal_rec.latest_balance_id);
82: