SELECT HRL.LOOKUP_CODE ID , HRL.MEANING VALUE , NVL(HRL.START_DATE_ACTIVE , HR_GENERAL.START_OF_TIME) START_DATE , NVL(HRL.END_DATE_ACTIVE , HR_GENERAL.END_OF_TIME) END_DATE , HRL.ENABLED_FLAG ENABLED_FLAG FROM HR_LOOKUPS HRL WHERE HRL.LOOKUP_TYPE = 'REC_TYPE' AND TRUNC(SYSDATE) BETWEEN NVL( HRL.START_DATE_ACTIVE , HR_GENERAL.START_OF_TIME) AND NVL(HRL.END_DATE_ACTIVE , HR_GENERAL.END_OF_TIME) UNION ALL SELECT 'NA_EDW' ID , '' VALUE , HR_GENERAL.START_OF_TIME START_DATE , HR_GENERAL.END_OF_TIME , 'Y' ENABLED_FLAG FROM DUAL