VIEW: APPS.PER_PERIODS_OF_SERVICE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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