VIEW: APPS.PER_JP_EMPDET_EMP_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'