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 LOOKUP_TYPE = 'PER_CATEGORIES' 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 END_DATE , 'Y' ENABLED_FLAG FROM DUAL WITH READ ONLY