[Home] [Help]
| Product: | PAY - Payroll |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.PAY_PAYMENT_TYPES_VL
|
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')