APPS.BEN_DM_DELETE dependencies on PER_CONTACT_RELATIONSHIPS

Line 47: per_contact_relationships pcr

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
50: and phs.phase_name = 'UP' --use UP phase for now
51: and mod(itm.phase_item_id,l_no_of_threads) + 1 = p_process_number

Line 268: delete from per_contact_relationships where person_id=p_person_id;

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