APPS.HR_PERSON_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F

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

2064: --
2065: -- bug fix 3732129 starts here.
2066: -- to improve performance assignment id fetched into a pl/sql table.
2067: --
2068: type assignmentid is table of per_all_assignments_f.assignment_id%type
2069: index by binary_integer;
2070: --
2071: l_assignment_id assignmentid;
2072: l_proc varchar2(72) := g_package||'delete_person';

Line 3419: delete from per_all_assignments_f a

3415: end if;
3416: --
3417: begin
3418: --
3419: delete from per_all_assignments_f a
3420: where a.person_id = P_PERSON_ID;
3421: --
3422: exception
3423: when NO_DATA_FOUND then