DBA Data[Home] [Help]

APPS.PQH_PQHUSASR_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 30: PER_ALL_PEOPLE_F PAP

26: FROM
27: PER_ALL_ASSIGNMENTS_F PAF,
28: PER_EVENTS PE,
29: HR_LOOKUPS HR,
30: PER_ALL_PEOPLE_F PAP
31: WHERE PE.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
32: AND PAP.PERSON_ID = PAF.PERSON_ID
33: AND PE.TYPE = HR.LOOKUP_CODE
34: AND SYSDATE BETWEEN PAF.EFFECTIVE_START_DATE