DBA Data[Home] [Help]

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 );