View: OKL_PAY_GROUP_UV

Product:	OKL - Leasing and Finance Management
Description:	View for list of values of Funding request Payment group
Implementation/DBA Data:	APPS.OKL_PAY_GROUP_UV

View Text

SELECT LV.LOOKUP_CODE LOOKUP_CODE
, LV.MEANING MEANING
, LV.DESCRIPTION DESCRIPTION
FROM FND_LOOKUP_VALUES LV
WHERE LV.LANGUAGE = USERENV('LANG')
AND LV.VIEW_APPLICATION_ID = 201
AND LV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LV.LOOKUP_TYPE
, LV.VIEW_APPLICATION_ID)
AND LV.LOOKUP_TYPE LIKE 'PAY GROUP'
AND LV.ENABLED_FLAG = 'Y'
AND TRUNC(NVL(LV.END_DATE_ACTIVE
, SYSDATE)) <= TRUNC(SYSDATE)

Columns