SELECT HRL.LOOKUP_CODE ID , HRL.MEANING VALUE , NVL(HRL.START_DATE_ACTIVE , HR_GENERAL.START_OF_TIME) DATE_FROM , NVL(HRL.END_DATE_ACTIVE , HR_GENERAL.END_OF_TIME) DATE_TO , HRL.ENABLED_FLAG VALID_CODE FROM HR_LOOKUPS HRL WHERE HRL.LOOKUP_TYPE = 'US_ETHNIC_GROUP' AND HRL.ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(HRL.START_DATE_ACTIVE) , HR_GENERAL.START_OF_TIME) AND NVL(TRUNC(HRL.END_DATE_ACTIVE) , HR_GENERAL.END_OF_TIME) UNION ALL SELECT 'NA_EDW' ID , '' VALUE , HR_GENERAL.START_OF_TIME DATE_FROM , HR_GENERAL.END_OF_TIME DATE_TO , 'Y' VALID_CODE FROM DUAL WITH READ ONLY