FND Design Data [Home] [Help]

View: PAY_PAYMENT_TYPES_VL

Product: PAY - Payroll
Description:
Implementation/DBA Data: ViewAPPS.PAY_PAYMENT_TYPES_VL
View Text

SELECT B.ROWID ROW_ID
, B.PAYMENT_TYPE_ID
, B.TERRITORY_CODE
, B.CURRENCY_CODE
, B.CATEGORY
, T.PAYMENT_TYPE_NAME
, B.ALLOW_AS_DEFAULT
, T.DESCRIPTION
, B.PRE_VALIDATION_REQUIRED
, B.PROCEDURE_NAME
, B.VALIDATION_DAYS
, B.VALIDATION_VALUE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.RECONCILIATION_FUNCTION
FROM PAY_PAYMENT_TYPES B
, PAY_PAYMENT_TYPES_TL T
WHERE B.PAYMENT_TYPE_ID = T.PAYMENT_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
PAYMENT_TYPE_ID
TERRITORY_CODE
CURRENCY_CODE
CATEGORY
PAYMENT_TYPE_NAME
ALLOW_AS_DEFAULT
DESCRIPTION
PRE_VALIDATION_REQUIRED
PROCEDURE_NAME
VALIDATION_DAYS
VALIDATION_VALUE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
RECONCILIATION_FUNCTION