APPS.PO_COMMUNICATION_PVT dependencies on HR_LOOKUPS
Line 7295: HR_LOOKUPS HRL
7291:
7292: FROM
7293: PER_ALL_PEOPLE_F HRE,
7294: PO_HEADERS_ARCHIVE_ALL PHA, 7295: HR_LOOKUPS HRL 7296: WHERE HRL.LOOKUP_CODE(+) = HRE.TITLE AND
7297: HRL.LOOKUP_TYPE(+) = 'TITLE' AND
7298: HRE.PERSON_ID = PHA.AGENT_ID AND
7299: --HRE.EMPLOYEE_NUMBER IS NOT NULL AND --