Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_PAYMENT_TYPE_V |
SELECT HR_BIS.BIS_DECODE_LOOKUP('PAYMENT_CATEGORY'
, PT.CATEGORY) CATEGORY_M
, TL.PAYMENT_TYPE_NAME
, TL.DESCRIPTION
, PT.ALLOW_AS_DEFAULT
, PT.PRE_VALIDATION_REQUIRED
, PT.PROCEDURE_NAME
, PT.VALIDATION_DAYS
, PT.VALIDATION_VALUE
, PT.RECONCILIATION_FUNCTION
, PT.CATEGORY
, PT.PAYMENT_TYPE_ID
, PT.TERRITORY_CODE
, PT.CURRENCY_CODE
, PT.LAST_UPDATE_DATE
, PT.LAST_UPDATED_BY
, PT.LAST_UPDATE_LOGIN
, PT.CREATED_BY
, PT.CREATION_DATE
FROM PAY_PAYMENT_TYPES PT
, PAY_PAYMENT_TYPES_TL TL
WHERE PT.PAYMENT_TYPE_ID = TL.PAYMENT_TYPE_ID
AND TL.LANGUAGE = USERENV('LANG') WITH READ ONLY