APPS.BEN_DM_DELETE dependencies on PER_ALL_ASSIGNMENTS_F

Line 183: from per_all_assignments_f

179: in (select element_entry_id
180: from pay_element_entries_f
181: where assignment_id in
182: (select assignment_id
183: from per_all_assignments_f
184: where person_id =p_person_id));
185:
186: delete from PAY_ELEMENT_ENTRIES_F
187: where assignment_id in

Line 189: from per_all_assignments_f

185:
186: delete from PAY_ELEMENT_ENTRIES_F
187: where assignment_id in
188: (select assignment_id
189: from per_all_assignments_f
190: where person_id =p_person_id);
191:
192: delete from ben_prtt_prem_f
193: where prtt_enrt_rslt_id in

Line 262: (select assignment_id from per_all_assignments_f where person_id=p_person_id);

258: --
259:
260: delete from per_addresses where person_id=p_person_id;
261: delete from per_assignment_extra_info where assignment_id in
262: (select assignment_id from per_all_assignments_f where person_id=p_person_id);
263:
264:
265: delete from per_all_assignments_f where person_id=p_person_id;
266: delete from per_person_type_usages_f where person_id=p_person_id;

Line 265: delete from per_all_assignments_f where person_id=p_person_id;

261: delete from per_assignment_extra_info where assignment_id in
262: (select assignment_id from per_all_assignments_f where person_id=p_person_id);
263:
264:
265: delete from per_all_assignments_f where person_id=p_person_id;
266: delete from per_person_type_usages_f where person_id=p_person_id;
267: delete from per_periods_of_service where person_id=p_person_id;
268: delete from per_contact_relationships where person_id=p_person_id;
269: delete from per_absence_attendances where person_id=p_person_id;