APPS.HR_DELETE dependencies on PAY_BALANCE_SET_MEMBERS

Line 230: pay_balance_sets, pay_balance_set_members.

226: a significant performance gain.
227: 115.16 02-JUL-01 N.Bristow Deleting from pay_event_procedures now.
228: 115.17 04-Sep-00 dsaxby Changes for purge (1682940).
229: - Added deletes for pay_us_asg_reporting,
230: pay_balance_sets, pay_balance_set_members.
231: - Update the secondary_status for any purge
232: assignment actions before attempting to
233: call rollback_payroll_action procedure.
234: 115.18 21-NOV-02 N.Bristow Now deleting from pay_element_types_f_tl,

Line 1731: DELETE FROM pay_balance_set_members bsm

1727: DELETE FROM pay_backpay_sets bs
1728: WHERE bs.business_group_id = p_business_group_id;
1729: hr_utility.set_location(l_proc,40);
1730: --
1731: DELETE FROM pay_balance_set_members bsm
1732: WHERE EXISTS ( SELECT ''
1733: FROM pay_balance_sets pbs
1734: WHERE pbs.balance_set_id = bsm.balance_set_id
1735: AND pbs.business_group_id = p_business_group_id);