APPS.HR_DELETE dependencies on PAY_LATEST_BALANCES

Line 250: 115.27 09-DEC-03 nbristow Now delete from pay_latest_balances.

246: 115.26 sep-2003 mbocutt Ex-person security enhancements. Remove
247: references to per_person_list_changes.
248: This file is now dependent on other
249: security changes delivered in Nov 2003 FP.
250: 115.27 09-DEC-03 nbristow Now delete from pay_latest_balances.
251: 115.28 12-DEC-03 nbristow Now delete from pay_upgrade_status.
252: 115.29 30-APR-04 alogue Performance Repository : remove deletion from
253: pay_quickpay_inclusions as occurs within rollback
254: anyway.

Line 605: from pay_latest_balances plb,

601: and paa.assignment_action_id = pplb.assignment_action_id
602: union all
603: select plb.latest_balance_id,
604: 'AP' bal_type
605: from pay_latest_balances plb,
606: pay_assignment_actions paa,
607: pay_payroll_actions ppa
608: where ppa.business_group_id = p_bg_id
609: and ppa.payroll_action_id = paa.payroll_action_id

Line 645: delete from pay_latest_balances

641: elsif lbrec.bal_type = 'PER' then
642: delete from pay_person_latest_balances
643: where latest_balance_id = lbrec.latest_balance_id;
644: else
645: delete from pay_latest_balances
646: where latest_balance_id = lbrec.latest_balance_id;
647: end if;
648: --
649: end loop;