VIEW: APPS.PER_PERIODS_OF_PLACEMENT_V

Source

View Text - Preformatted

SELECT PDP. PERIOD_OF_PLACEMENT_ID , PDP.OBJECT_VERSION_NUMBER , PDP.BUSINESS_GROUP_ID , PDP.PERSON_ID , PDP.DATE_START , PDP.ACTUAL_TERMINATION_DATE , PDP.FINAL_PROCESS_DATE , PDP.LAST_STANDARD_PROCESS_DATE , PDP.PROJECTED_TERMINATION_DATE , PDP.TERMINATION_REASON , HR_GENERAL.DECODE_LOOKUP('HR_CWK_TERMINATION_REASONS', PDP.TERMINATION_REASON) D_TERMINATION_REASON , PDP.ATTRIBUTE_CATEGORY , PDP.ATTRIBUTE1 , PDP.ATTRIBUTE2 , PDP.ATTRIBUTE3 , PDP.ATTRIBUTE4 , PDP.ATTRIBUTE5 , PDP.ATTRIBUTE6 , PDP.ATTRIBUTE7 , PDP.ATTRIBUTE8 , PDP.ATTRIBUTE9 , PDP.ATTRIBUTE10 , PDP.ATTRIBUTE11 , PDP.ATTRIBUTE12 , PDP.ATTRIBUTE13 , PDP.ATTRIBUTE14 , PDP.ATTRIBUTE15 , PDP.ATTRIBUTE16 , PDP.ATTRIBUTE17 , PDP.ATTRIBUTE18 , PDP.ATTRIBUTE19 , PDP.ATTRIBUTE20 , PDP.ATTRIBUTE21 , PDP.ATTRIBUTE22 , PDP.ATTRIBUTE23 , PDP.ATTRIBUTE24 , PDP.ATTRIBUTE25 , PDP.ATTRIBUTE26 , PDP.ATTRIBUTE27 , PDP.ATTRIBUTE28 , PDP.ATTRIBUTE29 , PDP.ATTRIBUTE30 , PDP.INFORMATION_CATEGORY , PDP.INFORMATION1 , PDP.INFORMATION2 , PDP.INFORMATION3 , PDP.INFORMATION4 , PDP.INFORMATION5 , PDP.INFORMATION6 , PDP.INFORMATION7 , PDP.INFORMATION8 , PDP.INFORMATION9 , PDP.INFORMATION10 , PDP.INFORMATION11 , PDP.INFORMATION12 , PDP.INFORMATION13 , PDP.INFORMATION14 , PDP.INFORMATION15 , PDP.INFORMATION16 , PDP.INFORMATION17 , PDP.INFORMATION18 , PDP.INFORMATION19 , PDP.INFORMATION20 , PDP.INFORMATION21 , PDP.INFORMATION22 , PDP.INFORMATION23 , PDP.INFORMATION24 , PDP.INFORMATION25 , PDP.INFORMATION26 , PDP.INFORMATION27 , PDP.INFORMATION28 , PDP.INFORMATION29 , PDP.INFORMATION30 , PDP.CREATED_BY , PDP.CREATION_DATE , PDP.LAST_UPDATED_BY , PDP.LAST_UPDATE_LOGIN , PDP.LAST_UPDATE_DATE FROM PER_PERIODS_OF_PLACEMENT PDP

View Text - HTML Formatted

SELECT PDP. PERIOD_OF_PLACEMENT_ID
, PDP.OBJECT_VERSION_NUMBER
, PDP.BUSINESS_GROUP_ID
, PDP.PERSON_ID
, PDP.DATE_START
, PDP.ACTUAL_TERMINATION_DATE
, PDP.FINAL_PROCESS_DATE
, PDP.LAST_STANDARD_PROCESS_DATE
, PDP.PROJECTED_TERMINATION_DATE
, PDP.TERMINATION_REASON
, HR_GENERAL.DECODE_LOOKUP('HR_CWK_TERMINATION_REASONS'
, PDP.TERMINATION_REASON) D_TERMINATION_REASON
, PDP.ATTRIBUTE_CATEGORY
, PDP.ATTRIBUTE1
, PDP.ATTRIBUTE2
, PDP.ATTRIBUTE3
, PDP.ATTRIBUTE4
, PDP.ATTRIBUTE5
, PDP.ATTRIBUTE6
, PDP.ATTRIBUTE7
, PDP.ATTRIBUTE8
, PDP.ATTRIBUTE9
, PDP.ATTRIBUTE10
, PDP.ATTRIBUTE11
, PDP.ATTRIBUTE12
, PDP.ATTRIBUTE13
, PDP.ATTRIBUTE14
, PDP.ATTRIBUTE15
, PDP.ATTRIBUTE16
, PDP.ATTRIBUTE17
, PDP.ATTRIBUTE18
, PDP.ATTRIBUTE19
, PDP.ATTRIBUTE20
, PDP.ATTRIBUTE21
, PDP.ATTRIBUTE22
, PDP.ATTRIBUTE23
, PDP.ATTRIBUTE24
, PDP.ATTRIBUTE25
, PDP.ATTRIBUTE26
, PDP.ATTRIBUTE27
, PDP.ATTRIBUTE28
, PDP.ATTRIBUTE29
, PDP.ATTRIBUTE30
, PDP.INFORMATION_CATEGORY
, PDP.INFORMATION1
, PDP.INFORMATION2
, PDP.INFORMATION3
, PDP.INFORMATION4
, PDP.INFORMATION5
, PDP.INFORMATION6
, PDP.INFORMATION7
, PDP.INFORMATION8
, PDP.INFORMATION9
, PDP.INFORMATION10
, PDP.INFORMATION11
, PDP.INFORMATION12
, PDP.INFORMATION13
, PDP.INFORMATION14
, PDP.INFORMATION15
, PDP.INFORMATION16
, PDP.INFORMATION17
, PDP.INFORMATION18
, PDP.INFORMATION19
, PDP.INFORMATION20
, PDP.INFORMATION21
, PDP.INFORMATION22
, PDP.INFORMATION23
, PDP.INFORMATION24
, PDP.INFORMATION25
, PDP.INFORMATION26
, PDP.INFORMATION27
, PDP.INFORMATION28
, PDP.INFORMATION29
, PDP.INFORMATION30
, PDP.CREATED_BY
, PDP.CREATION_DATE
, PDP.LAST_UPDATED_BY
, PDP.LAST_UPDATE_LOGIN
, PDP.LAST_UPDATE_DATE
FROM PER_PERIODS_OF_PLACEMENT PDP