SELECT LOOKUP_CODE , MEANING FROM PA_LOOKUPS WHERE LOOKUP_TYPE= 'SERVICE TYPE' AND ENABLED_FLAG = 'Y' 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= 'SERVICE TYPE' AND ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE))