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 )