VIEW: APPS.AHL_HZ_PER_EMPLOYEES_V

Source

View Text - Preformatted

SELECT PARTY_ID, PARTY_NUMBER, PARTY_NAME FROM HZ_PARTIES WHERE AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N','L') AND PARTY_TYPE ='PERSON' UNION SELECT PERSON_ID, EMPLOYEE_NUMBER, FULL_NAME FROM PER_PEOPLE_F PPF, PER_PERSON_TYPES PPT WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE AND NVL(CURRENT_EMPLOYEE_FLAG, 'X') = 'Y' AND PPF.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID AND SYSTEM_PERSON_TYPE ='EMP' AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('I','S')

View Text - HTML Formatted

SELECT PARTY_ID
, PARTY_NUMBER
, PARTY_NAME
FROM HZ_PARTIES
WHERE AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('N'
, 'L')
AND PARTY_TYPE ='PERSON' UNION SELECT PERSON_ID
, EMPLOYEE_NUMBER
, FULL_NAME
FROM PER_PEOPLE_F PPF
, PER_PERSON_TYPES PPT
WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
AND NVL(CURRENT_EMPLOYEE_FLAG
, 'X') = 'Y'
AND PPF.PERSON_TYPE_ID = PPT.PERSON_TYPE_ID
AND SYSTEM_PERSON_TYPE ='EMP'
AND AHL_DI_DOC_INDEX_PVT.GET_PRODUCT_INSTALL_STATUS('PER') IN ('I'
, 'S')