APPS.HR_DELETE dependencies on PER_PEOPLE_EXTRA_INFO

Line 194: per_people_extra_info.

190: delete per_position_extra_info and
191: per_job_extra_info.
192: 2 Added delete statement to
193: delete_person_direct to delete
194: per_people_extra_info.
195: 110.1 27-JAN-97 N.Bristow Now deleting balance types correctly.
196: 110.2 16-APR-98 SASmith Change required from
197: per_assignment_budget_values to
198: per_assignment_budget_values_f.

Line 1353: DELETE FROM per_people_extra_info pei

1349: FROM per_people_f per
1350: WHERE per.person_id = pog.source_id
1351: AND per.business_group_id = p_business_group_id);
1352: --
1353: DELETE FROM per_people_extra_info pei
1354: WHERE EXISTS (SELECT ''
1355: FROM per_people_f per
1356: WHERE per.person_id = pei.person_id
1357: AND per.business_group_id = p_business_group_id);