SELECT PEO.PERSON_ID ID , PEO.FULL_NAME VALUE , PEO.EFFECTIVE_START_DATE START_DATE , PEO.EFFECTIVE_END_DATE END_DATE , PEO.PARTY_ID PARTY_ID FROM PER_PEOPLE_F PEO WHERE TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE AND PEO.EFFECTIVE_END_DATE AND EXISTS (SELECT NULL FROM PER_ALL_VACANCIES VAC WHERE VAC.RECRUITER_ID = PEO.PERSON_ID) AND CURRENT_EMPLOYEE_FLAG = 'Y' UNION ALL SELECT -1 ID , '' VALUE , HR_GENERAL.START_OF_TIME START_DATE , HR_GENERAL.END_OF_TIME END_DATE , -1 PARTY_ID FROM DUAL WITH READ ONLY