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 = 'BUDGET_MEASUREMENT_TYPE' AND HRL.LOOKUP_CODE IN ('FTE' , 'HEAD') 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) WITH READ ONLY