APPS.BEN_DM_DELETE dependencies on PER_ALL_PEOPLE_F

Line 24: per_all_people_f per,

20: select distinct per.person_id, dif.group_order
21: from ben_dm_phase_items itm,
22: ben_dm_phases phs,
23: ben_dm_input_file dif,
24: per_all_people_f per,
25: per_business_groups bg
26: where phs.migration_id = p_migration_id
27: and phs.phase_id = itm.phase_id
28: and phs.phase_name = 'UP' --use UP phase for now

Line 45: per_all_people_f per,

41: select distinct per.person_id
42: from ben_dm_phase_items itm,
43: ben_dm_phases phs,
44: ben_dm_input_file dif,
45: per_all_people_f per,
46: per_business_groups bg,
47: per_contact_relationships pcr
48: where phs.migration_id = p_migration_id
49: and phs.phase_id = itm.phase_id

Line 270: delete from per_all_people_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;
270: delete from per_all_people_f where person_id=p_person_id;
271:
272: hr_general.g_data_migrator_mode := 'N';
273:
274: exception