DBA Data[Home] [Help]

APPS.HXC_HXCRTERR_XMLP_PKG dependencies on PER_PEOPLE_F

Line 11: PER_PEOPLE_F PPF

7: PPF.LAST_NAME,
8: NVL(PPF.EMPLOYEE_NUMBER
9: ,PPF.NPW_NUMBER) EMPLOYEE_NUMBER
10: FROM
11: PER_PEOPLE_F PPF
12: WHERE PPF.PERSON_ID = CP_PERSON_ID
13: AND CP_EFFECTIVE_DATE between PPF.EFFECTIVE_START_DATE
14: AND PPF.EFFECTIVE_END_DATE;
15: BEGIN