APPS.HR_PERSON_DELETE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1022: from per_assignment_extra_info i

1018: into v_delete_permitted
1019: from sys.dual
1020: where not exists (
1021: select null
1022: from per_assignment_extra_info i
1023: where exists (
1024: select null
1025: from per_assignments_f a
1026: where a.person_id = P_PERSON_ID

Line 1912: delete from per_assignment_extra_info a

1908: --
1909: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 21);
1910: --
1911: begin
1912: delete from per_assignment_extra_info a
1913: where a.assignment_id in (
1914: select ass.assignment_id
1915: from per_assignments_f ass
1916: where ass.person_id = P_PERSON_ID);