APPS.PA_PAXAUMTC_XMLP_PKG dependencies on PER_PEOPLE_F

Line 63: from per_people_f

59: then
60: begin
61: select substr(full_name,1,40)
62: into hold_employee_name
63: from per_people_f
64: where person_id = employee_id
65: and ((sysdate between effective_start_date
66: and nvl(effective_end_date,sysdate + 1))
67: or (effective_start_date > sysdate))

Line 90: from per_people_f

86: IF supervisor is not null then
87: begin
88: select substr(full_name,1,30)
89: into person_name
90: from per_people_f
91: where person_id = supervisor
92: and ((sysdate between effective_start_date
93: and nvl(effective_end_date,sysdate + 1))
94: or (effective_start_date > sysdate))