APPS.PA_PAXEMRAO_XMLP_PKG dependencies on PER_PEOPLE_F
Line 68: from per_people_f
64: If p_person_id is not null
65: then
66: select substr(full_name,1,50)
67: into hold_employee_name 68: from per_people_f 69: where person_id = p_person_id
70: and sysdate between effective_start_date
71: and nvl(effective_end_date,sysdate + 1)
72: and (employee_number IS NOT NULL OR npw_number IS NOT NULL );