APPS.HR_PERSON_DELETE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1023: from per_assignment_extra_info i

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

Line 1983: delete from per_assignment_extra_info a

1979: --
1980: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 21);
1981: --
1982: begin
1983: delete from per_assignment_extra_info a
1984: where a.assignment_id in (
1985: select ass.assignment_id
1986: from per_assignments_f ass
1987: where ass.person_id = P_PERSON_ID);