SELECT lookup_code pay_group_lookup_code FROM FND_LOOKUP_VALUES WHERE lookup_type = 'PAY GROUP' and enabled_flag = 'Y' and nvl(end_date_active, sysdate+1) > sysdate
View Text - HTML Formatted
SELECT LOOKUP_CODE PAY_GROUP_LOOKUP_CODE FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'PAY GROUP' AND ENABLED_FLAG = 'Y' AND NVL(END_DATE_ACTIVE , SYSDATE+1) > SYSDATE