APPS.HR_DELETE dependencies on PER_PERSON_LIST

Line 247: references to per_person_list_changes.

243: pay_monetary_units_tl in
244: delete_assign_low_detail.
245: 115.25 28-AUG-03 nbristow Added procedure delete_retro_details.
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.

Line 2214: per_person_list pl

2210: -- and otherwise it is not a very high cost.
2211: CURSOR pev IS
2212: SELECT pp.person_id
2213: FROM per_people_f pp,
2214: per_person_list pl
2215: WHERE pp.person_id = pl.person_id
2216: AND pp.business_group_id = p_business_group_id;
2217: BEGIN
2218: --

Line 2233: DELETE FROM per_person_list pl

2229: AND pay.business_group_id = p_business_group_id);
2230: hr_utility.set_location(l_proc,40);
2231: --
2232: FOR pevrec IN pev LOOP
2233: DELETE FROM per_person_list pl
2234: WHERE pl.person_id = pevrec.person_id;
2235: END LOOP;
2236: hr_utility.set_location(l_proc,50);
2237: --