Product: | PAY - Payroll |
---|---|
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: | APPS.PAY_JP_ITWB_SAL_ACT_EFD_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_DATE.CANONICAL_TO_DATE(COL_MTH1)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH2)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH3)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH4)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH5)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH6)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH7)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH8)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH9)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH10)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH11)
, FND_DATE.CANONICAL_TO_DATE(COL_MTH12)
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
FROM PAY_JP_ITWB_SAL_ACT_V
WHERE CATEGORY = 'EFD'