SELECT LOOKUP_CODE , MEANING FROM PA_LOOKUPS WHERE LOOKUP_TYPE = 'BUDGET CHANGE REASON' AND TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE))
View Text - HTML Formatted
SELECT LOOKUP_CODE , MEANING FROM PA_LOOKUPS WHERE LOOKUP_TYPE = 'BUDGET CHANGE REASON' AND TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE))