SELECT meaning , lookup_code FROM pa_lookups WHERE lookup_type = 'RATE AND DISCOUNT REASON' AND trunc(nvl(end_date_active,sysdate)) >= trunc(sysdate)
View Text - HTML Formatted
SELECT MEANING , LOOKUP_CODE FROM PA_LOOKUPS WHERE LOOKUP_TYPE = 'RATE AND DISCOUNT REASON' AND TRUNC(NVL(END_DATE_ACTIVE , SYSDATE)) >= TRUNC(SYSDATE)