DBA Data[Home] [Help]

APPS.PA_PAXEXONE_XMLP_PKG dependencies on PER_PEOPLE_F

Line 69: from per_people_f

65: IF employee_id is not null
66: THEN
67: select SUBSTR(full_name,1,80)
68: into hold_employee_name
69: from per_people_f
70: where person_id = employee_id
71: and sysdate between effective_start_date
72: and nvl(effective_end_date,sysdate + 1)
73: and (employee_number IS NOT NULL or npw_number IS NOT NULL);