SELECT *
FROM apps.fnd_lookup_values flv
WHERE flv.lookup_type = 'PAY GROUP'
AND flv.LANGUAGE = USERENV ('LANG')
AND flv.enabled_flag = 'Y'
AND SYSDATE BETWEEN NVL (flv.START_DATE_ACTIVE, SYSDATE)
AND NVL (flv.END_DATE_ACTIVE, SYSDATE)
LOOKUP_CODE will be AP_SUPPLIER_SITES_ALL.PAY_GROUP_LOOKUP_CODE or PO_VENDOR_SITES_ALL.PAY_GROUP_LOOKUP_CODE
No comments:
Post a Comment