View: AHL_HZ_PER_EMPLOYEES_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This stores employee information.
Implementation/DBA Data:	APPS.AHL_HZ_PER_EMPLOYEES_V

View Text

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')

Columns