Product: | PER - Human Resources |
---|---|
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: | APPS.PER_JP_EMPDET_EMP_V |
SELECT PAI.ROWID
, PAI.ACTION_INFORMATION_ID
, PAI.OBJECT_VERSION_NUMBER
, PAI.ACTION_CONTEXT_ID
, PAI.ACTION_CONTEXT_TYPE
, PAI.ASSIGNMENT_ID
, PAI.EFFECTIVE_DATE
, PAI.ACTION_INFORMATION_CATEGORY
, PAI.ACTION_INFORMATION1
, PAI.ACTION_INFORMATION2
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION3)
, PAI.ACTION_INFORMATION4
, PAI.ACTION_INFORMATION5
, PAI.ACTION_INFORMATION6
, PAI.ACTION_INFORMATION7
, PAI.ACTION_INFORMATION8
, PAI.ACTION_INFORMATION9
, PAI.ACTION_INFORMATION10
, PAI.ACTION_INFORMATION11
, PAI.ACTION_INFORMATION12
, PAI.ACTION_INFORMATION13
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION14)
, PAI.ACTION_INFORMATION15
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION16)
, PAI.ACTION_INFORMATION17
, PAI.ACTION_INFORMATION19
, PAI.ACTION_INFORMATION20
, PAI.ACTION_INFORMATION21
, PAI.ACTION_INFORMATION22
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION23)
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION24)
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION25)
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION26)
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION27)
, FND_DATE.CANONICAL_TO_DATE(PAI.ACTION_INFORMATION28)
, PAI.ACTION_INFORMATION29
, PAI.ACTION_INFORMATION30
, PAI.LAST_UPDATE_LOGIN
, PAI.LAST_UPDATED_BY
, PAI.LAST_UPDATE_DATE
, PAI.CREATED_BY
, PAI.CREATION_DATE
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_INFORMATION_CATEGORY = 'JP_EMPDET_EMP'