SELECT HRL.LOOKUP_CODE ID , HRL.MEANING VALUE , HRL.DESCRIPTION , HRL.ENABLED_FLAG , HRL.START_DATE_ACTIVE START_DATE , HRL.END_DATE_ACTIVE END_DATE FROM HR_LOOKUPS HRL WHERE LOOKUP_TYPE = 'IRC_VARIABLE_COMP_ELEMENT' 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 , TO_CHAR(NULL) DESCRIPTION , 'Y' , HR_GENERAL.START_OF_TIME START_DATE , HR_GENERAL.END_OF_TIME END_DATE FROM DUAL WITH READ ONLY