SELECT lookup_code Payment_method_code FROM FND_LOOKUPS WHERE lookup_type = 'OKL_PAYMENT_METHODS' and enabled_flag = 'Y' and nvl(end_date_active, sysdate+1) > sysdate
View Text - HTML Formatted
SELECT LOOKUP_CODE PAYMENT_METHOD_CODE FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'OKL_PAYMENT_METHODS' AND ENABLED_FLAG = 'Y' AND NVL(END_DATE_ACTIVE , SYSDATE+1) > SYSDATE