DBA Data[Home] [Help]

VIEW: APPS.OKL_BPD_PAY_GRP_LOOKUP_CODES_V

Source

View Text - Preformatted

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