SELECT REQ.REQUISITION_ID ID , REQ.NAME VALUE , REQ.DATE_FROM START_DATE , REQ.DATE_TO DATE_TO , REQ.BUSINESS_GROUP_ID BUSINESS_GROUP_ID FROM PER_REQUISITIONS REQ WHERE TRUNC(SYSDATE) BETWEEN REQ.DATE_FROM AND NVL(REQ.DATE_TO , HR_GENERAL.END_OF_TIME) AND REQ.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID , REQ.BUSINESS_GROUP_ID) 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