DBA Data[Home] [Help]

APPS.PQH_PQHUSNRW_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 24: PER_ALL_PEOPLE_F PAP

20: FROM
21: PER_ALL_ASSIGNMENTS_F PAF,
22: PER_EVENTS PE,
23: HR_LOOKUPS HR,
24: PER_ALL_PEOPLE_F PAP
25: WHERE PE.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
26: AND PAP.PERSON_ID = PAF.PERSON_ID
27: AND PE.TYPE = HR.LOOKUP_CODE
28: AND SYSDATE BETWEEN PAF.EFFECTIVE_START_DATE