SELECT 'DEFAULT' ORGANIZATION_ID , 'ALL OPERATING UNITS' NAME FROM DUAL UNION SELECT TO_CHAR(HROPERATINGUNITS.ORGANIZATION_ID) ORGANIZATION_ID , HROPERATINGUNITS.NAME FROM HR_OPERATING_UNITS HROPERATINGUNITS WHERE TRUNC(SYSDATE) BETWEEN NVL(HROPERATINGUNITS.DATE_FROM , TRUNC(SYSDATE)) AND NVL(HROPERATINGUNITS.DATE_TO , TRUNC(SYSDATE))