Product: | PAY - Payroll |
---|---|
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: | APPS.PAY_JP_ITWB_BON_ACT_PAY_V |
SELECT ROW_ID
, ACTION_INFORMATION_ID
, OBJECT_VERSION_NUMBER
, ASSIGNMENT_ACTION_ID
, ACTION_CONTEXT_TYPE
, ASSIGNMENT_ID
, EFFECTIVE_DATE
, ACTION_INFORMATION_CATEGORY
, CATEGORY
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT1)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT2)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT3)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT4)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT5)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT6)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT7)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT8)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT9)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT10)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT11)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT12)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT13)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT14)
, FND_NUMBER.CANONICAL_TO_NUMBER(COL_CNT15)
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM PAY_JP_ITWB_BON_ACT_V
WHERE CATEGORY = 'PAY'