View: PA_EMPLOYEES_ADMIN_V

Product:	PA - Projects
Description:	For Online Expenditure Entry Form
Implementation/DBA Data:	APPS.PA_EMPLOYEES_ADMIN_V

View Text

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 )

Columns