View: PAYLV_PAYMENT_TYPE_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYLV_PAYMENT_TYPE_V

View Text

SELECT PPTT.PAYMENT_TYPE_NAME
, PPT.PAYMENT_TYPE_ID
, PPTT.PAYMENT_TYPE_NAME ORDER_BY
FROM PAY_PAYMENT_TYPES PPT
, PAY_PAYMENT_TYPES_TL PPTT
WHERE PPT.PAYMENT_TYPE_ID = PPTT.PAYMENT_TYPE_ID
AND PPTT.LANGUAGE = USERENV('LANG') UNION ALL SELECT NULL
, -1
, ' ' ORDER_BY
FROM DUAL WITH READ ONLY

Columns