Product: | PER - Human Resources |
---|---|
Description: | Periods of placement for contingent workers |
Implementation/DBA Data: | APPS.PER_PERIODS_OF_PLACEMENT_V |
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_UPDATE_LOGIN
, PDP.LAST_UPDATED_BY
, PDP.LAST_UPDATE_DATE
FROM PER_PERIODS_OF_PLACEMENT PDP