SELECT LK.LOOKUP_CODE , LK.MEANING FROM FND_LOOKUPS LK WHERE LK.LOOKUP_TYPE = 'ZX_EXEMPTION_REASON_CODE' AND LK.ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(LK.START_DATE_ACTIVE , SYSDATE)) AND TRUNC(NVL(LK.END_DATE_ACTIVE , SYSDATE)) ORDER BY MEANING