VIEW: APPS.PA_EMPLOYEES_ADMIN_V

Source

View Text - Preformatted

SELECT DISTINCT PERSON_ID , FULL_NAME , NVL ( P.EMPLOYEE_NUMBER , P.NPW_NUMBER ) FROM PER_PEOPLE_F P WHERE pa_admin_ext.allowed_all(P.PERSON_ID) = 'TRUE' AND TRUNC(SYSDATE) BETWEEN TRUNC (P.EFFECTIVE_START_DATE) AND TRUNC (P.EFFECTIVE_END_DATE) AND ( P.EMPLOYEE_NUMBER IS NOT NULL OR P.NPW_NUMBER IS NOT NULL )

View Text - HTML Formatted

SELECT DISTINCT PERSON_ID
, FULL_NAME
, NVL ( P.EMPLOYEE_NUMBER
, P.NPW_NUMBER )
FROM PER_PEOPLE_F P
WHERE PA_ADMIN_EXT.ALLOWED_ALL(P.PERSON_ID) = 'TRUE'
AND TRUNC(SYSDATE) BETWEEN TRUNC (P.EFFECTIVE_START_DATE)
AND TRUNC (P.EFFECTIVE_END_DATE)
AND ( P.EMPLOYEE_NUMBER IS NOT NULL OR P.NPW_NUMBER IS NOT NULL )