APPS.PA_PAXAUMTC_XMLP_PKG dependencies on PER_PEOPLE_F

Line 63: from per_people_f

59: If employee_id is not null
60: then
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 83: from per_people_f

79:
80: IF supervisor is not null then
81: select substr(full_name,1,30)
82: into person_name
83: from per_people_f
84: where person_id = supervisor
85: and ((sysdate between effective_start_date
86: and nvl(effective_end_date,sysdate + 1))
87: or (effective_start_date > sysdate))