SELECT VAC.VACANCY_ID ID , VAC.NAME VALUE , VAC.DATE_FROM START_DATE , NVL(VAC.DATE_TO , HR_GENERAL.END_OF_TIME) END_DATE , VAC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID FROM PER_VACANCIES VAC WHERE TRUNC(SYSDATE) BETWEEN VAC.DATE_FROM AND NVL(VAC.DATE_TO , HR_GENERAL.END_OF_TIME) UNION ALL SELECT -1 ID , '' VALUE , HR_GENERAL.START_OF_TIME START_DATE , HR_GENERAL.END_OF_TIME END_DATE , -1 BUSINESS_GROUP_ID FROM DUAL WITH READ ONLY