APPS.HR_PERSON_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 2036: type assignmentid is table of per_all_assignments_f.assignment_id%type

2032: --
2033: -- bug fix 3732129 starts here.
2034: -- to improve performance assignment id fetched into a pl/sql table.
2035: --
2036: type assignmentid is table of per_all_assignments_f.assignment_id%type
2037: index by binary_integer;
2038: --
2039: l_assignment_id assignmentid;
2040: l_proc varchar2(72) := g_package||'delete_person';

Line 3366: delete from per_all_assignments_f a

3362: end if;
3363: --
3364: begin
3365: --
3366: delete from per_all_assignments_f a
3367: where a.person_id = P_PERSON_ID;
3368: --
3369: exception
3370: when NO_DATA_FOUND then