View: PAY_PAYMENT_TYPE_LOV

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_PAYMENT_TYPE_LOV

View Text

SELECT PTTL.PAYMENT_TYPE_NAME
, PT.PAYMENT_TYPE_ID
, PT.TERRITORY_CODE
, TERR.TERRITORY_SHORT_NAME
, PT.CURRENCY_CODE
, PT.CATEGORY
, PT.PAYMENT_TYPE_NAME PMETH_INFORMATION_CATEGORY
FROM PAY_PAYMENT_TYPES PT
, PAY_PAYMENT_TYPES_TL PTTL
, FND_TERRITORIES_VL TERR
WHERE PT.PAYMENT_TYPE_ID = PTTL.PAYMENT_TYPE_ID
AND PTTL.LANGUAGE = USERENV('LANG')
AND PT.TERRITORY_CODE = TERR.TERRITORY_CODE(+)

Columns