Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_PAYMENT_TYPES_V |
SELECT PT.ROWID ROW_ID
, PT.PAYMENT_TYPE_ID
, PT.TERRITORY_CODE
, PT.CURRENCY_CODE
, PT.CATEGORY
, PTTL.PAYMENT_TYPE_NAME
, PT.PAYMENT_TYPE_NAME BASE_PAYMENT_TYPE_NAME
, PT.ALLOW_AS_DEFAULT
, PTTL.DESCRIPTION
, PT.PRE_VALIDATION_REQUIRED
, PT.PROCEDURE_NAME
, PT.VALIDATION_DAYS
, PT.VALIDATION_VALUE
, PT.LAST_UPDATE_DATE
, PT.LAST_UPDATED_BY
, PT.LAST_UPDATE_LOGIN
, PT.CREATED_BY
, PT.CREATION_DATE
, TERR.TERRITORY_SHORT_NAME
, CURR.NAME
, HR.MEANING D_CATEGORY
FROM PAY_PAYMENT_TYPES PT
, PAY_PAYMENT_TYPES_TL PTTL
, FND_TERRITORIES_VL TERR
, FND_CURRENCIES_VL CURR
, HR_LOOKUPS HR
WHERE PT.PAYMENT_TYPE_ID = PTTL.PAYMENT_TYPE_ID
AND PTTL.LANGUAGE = USERENV('LANG')
AND PT.TERRITORY_CODE = TERR.TERRITORY_CODE(+)
AND PT.CURRENCY_CODE = CURR.CURRENCY_CODE(+)
AND PT.CATEGORY = HR.LOOKUP_CODE
AND HR.LOOKUP_TYPE = 'PAYMENT_CATEGORY'