APPS.PAY_US_GROSSUP_UPD dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

Line 67: FROM pay_assignment_latest_balances

63: WHERE balance_dimension_id = p_dim_id;
64:
65: CURSOR get_latest_bal IS
66: SELECT latest_balance_id
67: FROM pay_assignment_latest_balances
68: WHERE latest_balance_id BETWEEN p_start_latest_bal_id
69: AND p_end_latest_bal_id
70: AND defined_balance_id = l_defined_bal_id;
71:

Line 89: delete from pay_assignment_latest_balances

85:
86: --hr_utility.trace('Deleted context value '||latebal_rec.latest_balance_id);
87:
88: --
89: delete from pay_assignment_latest_balances
90: where latest_balance_id = latebal_rec.latest_balance_id;
91:
92: --hr_utility.trace('Deleted asg late bal '||latebal_rec.latest_balance_id);
93: