Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_PERIODS_OF_SERVICE_V |
SELECT PPS.ROWID
, PERIOD_OF_SERVICE_ID
, PPS.BUSINESS_GROUP_ID + 0
, PPS.PERSON_ID
, DATE_START
, TERMINATION_ACCEPTED_PERSON_ID
, ACCEPTED_TERMINATION_DATE
, ACTUAL_TERMINATION_DATE
, COMMENTS
, FINAL_PROCESS_DATE
, LAST_STANDARD_PROCESS_DATE
, LEAVING_REASON
, NOTIFIED_TERMINATION_DATE
, PROJECTED_TERMINATION_DATE
, PPS.REQUEST_ID
, PPS.PROGRAM_APPLICATION_ID
, PPS.PROGRAM_ID
, PPS.PROGRAM_UPDATE_DATE
, PPS.ATTRIBUTE_CATEGORY
, PPS.ATTRIBUTE1
, PPS.ATTRIBUTE2
, PPS.ATTRIBUTE3
, PPS.ATTRIBUTE4
, PPS.ATTRIBUTE5
, PPS.ATTRIBUTE6
, PPS.ATTRIBUTE7
, PPS.ATTRIBUTE8
, PPS.ATTRIBUTE9
, PPS.ATTRIBUTE10
, PPS.ATTRIBUTE11
, PPS.ATTRIBUTE12
, PPS.ATTRIBUTE13
, PPS.ATTRIBUTE14
, PPS.ATTRIBUTE15
, PPS.ATTRIBUTE16
, PPS.ATTRIBUTE17
, PPS.ATTRIBUTE18
, PPS.ATTRIBUTE19
, PPS.ATTRIBUTE20
, PPS.LAST_UPDATE_DATE
, PPS.LAST_UPDATED_BY
, PPS.LAST_UPDATE_LOGIN
, PPS.CREATED_BY
, PPS.CREATION_DATE
, L.MEANING
, PPS.ADJUSTED_SVC_DATE
, PPS.PDS_INFORMATION_CATEGORY
, PPS.PDS_INFORMATION1
, PPS.PDS_INFORMATION2
, PPS.PDS_INFORMATION3
, PPS.PDS_INFORMATION4
, PPS.PDS_INFORMATION5
, PPS.PDS_INFORMATION6
, PPS.PDS_INFORMATION7
, PPS.PDS_INFORMATION8
, PPS.PDS_INFORMATION9
, PPS.PDS_INFORMATION10
, PPS.PDS_INFORMATION11
, PPS.PDS_INFORMATION12
, PPS.PDS_INFORMATION13
, PPS.PDS_INFORMATION14
, PPS.PDS_INFORMATION15
, PPS.PDS_INFORMATION16
, PPS.PDS_INFORMATION17
, PPS.PDS_INFORMATION18
, PPS.PDS_INFORMATION19
, PPS.PDS_INFORMATION20
, PPS.PDS_INFORMATION21
, PPS.PDS_INFORMATION22
, PPS.PDS_INFORMATION23
, PPS.PDS_INFORMATION24
, PPS.PDS_INFORMATION25
, PPS.PDS_INFORMATION26
, PPS.PDS_INFORMATION27
, PPS.PDS_INFORMATION28
, PPS.PDS_INFORMATION29
, PPS.PDS_INFORMATION30
, PPS.OBJECT_VERSION_NUMBER
FROM PER_PERIODS_OF_SERVICE PPS
, HR_LOOKUPS L
WHERE L.LOOKUP_TYPE(+) = 'LEAV_REAS'
AND L.LOOKUP_CODE(+) = PPS.LEAVING_REASON