SELECT MEANING ,LOOKUP_CODE from OE_LOOKUPS WHERE LOOKUP_TYPE = 'CREDIT_CARD' AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE)
View Text - HTML Formatted
SELECT MEANING , LOOKUP_CODE FROM OE_LOOKUPS WHERE LOOKUP_TYPE = 'CREDIT_CARD' AND ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE , SYSDATE) AND NVL(END_DATE_ACTIVE , SYSDATE)