SELECT MEANING RETURN_REFERENCE_TYPE , LOOKUP_CODE RETURN_REFERENCE_TYPE_CODE , DESCRIPTION FROM OE_LOOKUPS WHERE LOOKUP_TYPE = 'REFERENCE_TYPE' AND ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE , TRUNC(SYSDATE)) AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE))