DBA Data[Home] [Help]

APPS.PA_PAXPCTCE_XMLP_PKG dependencies on PER_PEOPLE_F

Line 53: from per_people_f

49: If employee_id is not null
50: then
51: select full_name
52: into hold_employee_name
53: from per_people_f
54: where person_id = PA_PAXPCTCE_XMLP_PKG.employee_id
55: and sysdate between effective_start_date
56: and nvl(effective_end_date,sysdate + 1)
57: and ( employee_number IS NOT NULL or npw_number IS NOT NULL);