SELECT P.PERSON_ID , P.FULL_NAME , DECODE(P.CURRENT_EMPLOYEE_FLAG , 'Y' , P.EMPLOYEE_NUMBER , P.NPW_NUMBER) , L.MEANING FROM PER_PEOPLE_F P , PA_LOOKUPS L WHERE L.LOOKUP_TYPE = 'PA_PERSON_TYPE' AND L.LOOKUP_CODE = DECODE(P.CURRENT_EMPLOYEE_FLAG , 'Y' , 'EMP' , 'CWK') AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND (P.EMPLOYEE_NUMBER IS NOT NULL OR P.NPW_NUMBER IS NOT NULL) AND EXISTS (SELECT NULL FROM PA_PROJECT_PLAYERS PP , PA_PROJECTS PR WHERE PP.PERSON_ID = P.PERSON_ID AND PP.PROJECT_ID = PR.PROJECT_ID )