VIEW: APPS.PER_CONTRACTS

Source

View Text - Preformatted

SELECT pcf1.ROWID, pcf1.CONTRACT_ID, hr_contract_api.get_active_start_date (pcf1.contract_id,fs.effective_date,pcf1.status), hr_contract_api.get_active_end_date (pcf1.contract_id,fs.effective_date,pcf1.status), pcf1.EFFECTIVE_START_DATE, pcf1.EFFECTIVE_END_DATE, hr_contract_api.get_pps_start_date (pcf1.person_id, hr_contract_api.get_active_start_date (pcf1.contract_id,fs.effective_date,pcf1.status)), hr_contract_api.get_pps_end_date (pcf1.person_id,hr_contract_api.get_active_start_date (pcf1.contract_id,fs.effective_date,pcf1.status)), pcf1.PERSON_ID, pcf1.REFERENCE, pcf1.OBJECT_VERSION_NUMBER, pcf1.BUSINESS_GROUP_ID, pcf1.TYPE, hr_contract_api.get_meaning(pcf1.TYPE, 'CONTRACT_TYPE'), pcf1.STATUS, hr_contract_api.get_meaning(pcf1.STATUS,'CONTRACT_STATUS'), pcf1.STATUS_REASON, hr_contract_api.get_meaning(pcf1.STATUS_REASON,'CONTRACT_STATUS_REASON'), pcf1.doc_status, hr_contract_api.get_meaning(pcf1.doc_status, 'DOCUMENT_STATUS'), pcf1.doc_status_change_date, pcf1.DESCRIPTION, pcf1.DURATION, pcf1.DURATION_UNITS, hr_contract_api.get_meaning(pcf1.DURATION_UNITS,'QUALIFYING_UNITS'), pcf1.CONTRACTUAL_JOB_TITLE, pcf1.PARTIES, pcf1.START_REASON, hr_contract_api.get_meaning(pcf1.START_REASON,'CONTRACT_START_REASON'), pcf1.END_REASON, hr_contract_api.get_meaning(pcf1.END_REASON,'CONTRACT_END_REASON'), pcf1.NUMBER_OF_EXTENSIONS, pcf1.EXTENSION_REASON, pcf1.EXTENSION_PERIOD, pcf1.EXTENSION_PERIOD_UNITS, hr_contract_api.get_meaning(pcf1.EXTENSION_PERIOD_UNITS,'QUALIFYING_UNITS'), pcf1.CTR_INFORMATION_CATEGORY, pcf1.CTR_INFORMATION1, pcf1.CTR_INFORMATION2, pcf1.CTR_INFORMATION3, pcf1.CTR_INFORMATION4, pcf1.CTR_INFORMATION5, pcf1.CTR_INFORMATION6, pcf1.CTR_INFORMATION7, pcf1.CTR_INFORMATION8, pcf1.CTR_INFORMATION9, pcf1.CTR_INFORMATION10, pcf1.CTR_INFORMATION11, pcf1.CTR_INFORMATION12, pcf1.CTR_INFORMATION13, pcf1.CTR_INFORMATION14, pcf1.CTR_INFORMATION15, pcf1.CTR_INFORMATION16, pcf1.CTR_INFORMATION17, pcf1.CTR_INFORMATION18, pcf1.CTR_INFORMATION19, pcf1.CTR_INFORMATION20, pcf1.ATTRIBUTE_CATEGORY, pcf1.ATTRIBUTE1, pcf1.ATTRIBUTE2, pcf1.ATTRIBUTE3, pcf1.ATTRIBUTE4, pcf1.ATTRIBUTE5, pcf1.ATTRIBUTE6, pcf1.ATTRIBUTE7, pcf1.ATTRIBUTE8, pcf1.ATTRIBUTE9, pcf1.ATTRIBUTE10, pcf1.ATTRIBUTE11, pcf1.ATTRIBUTE12, pcf1.ATTRIBUTE13, pcf1.ATTRIBUTE14, pcf1.ATTRIBUTE15, pcf1.ATTRIBUTE16, pcf1.ATTRIBUTE17, pcf1.ATTRIBUTE18, pcf1.ATTRIBUTE19, pcf1.ATTRIBUTE20, pcf1.LAST_UPDATE_DATE, pcf1.LAST_UPDATED_BY, pcf1.LAST_UPDATE_LOGIN, pcf1.CREATED_BY, pcf1.CREATION_DATE from per_contracts_f pcf1, fnd_sessions fs WHERE fs.session_id = userenv('sessionid') and fs.effective_date between pcf1.effective_start_date and pcf1.effective_end_date

View Text - HTML Formatted

SELECT PCF1.ROWID
, PCF1.CONTRACT_ID
, HR_CONTRACT_API.GET_ACTIVE_START_DATE (PCF1.CONTRACT_ID
, FS.EFFECTIVE_DATE
, PCF1.STATUS)
, HR_CONTRACT_API.GET_ACTIVE_END_DATE (PCF1.CONTRACT_ID
, FS.EFFECTIVE_DATE
, PCF1.STATUS)
, PCF1.EFFECTIVE_START_DATE
, PCF1.EFFECTIVE_END_DATE
, HR_CONTRACT_API.GET_PPS_START_DATE (PCF1.PERSON_ID
, HR_CONTRACT_API.GET_ACTIVE_START_DATE (PCF1.CONTRACT_ID
, FS.EFFECTIVE_DATE
, PCF1.STATUS))
, HR_CONTRACT_API.GET_PPS_END_DATE (PCF1.PERSON_ID
, HR_CONTRACT_API.GET_ACTIVE_START_DATE (PCF1.CONTRACT_ID
, FS.EFFECTIVE_DATE
, PCF1.STATUS))
, PCF1.PERSON_ID
, PCF1.REFERENCE
, PCF1.OBJECT_VERSION_NUMBER
, PCF1.BUSINESS_GROUP_ID
, PCF1.TYPE
, HR_CONTRACT_API.GET_MEANING(PCF1.TYPE
, 'CONTRACT_TYPE')
, PCF1.STATUS
, HR_CONTRACT_API.GET_MEANING(PCF1.STATUS
, 'CONTRACT_STATUS')
, PCF1.STATUS_REASON
, HR_CONTRACT_API.GET_MEANING(PCF1.STATUS_REASON
, 'CONTRACT_STATUS_REASON')
, PCF1.DOC_STATUS
, HR_CONTRACT_API.GET_MEANING(PCF1.DOC_STATUS
, 'DOCUMENT_STATUS')
, PCF1.DOC_STATUS_CHANGE_DATE
, PCF1.DESCRIPTION
, PCF1.DURATION
, PCF1.DURATION_UNITS
, HR_CONTRACT_API.GET_MEANING(PCF1.DURATION_UNITS
, 'QUALIFYING_UNITS')
, PCF1.CONTRACTUAL_JOB_TITLE
, PCF1.PARTIES
, PCF1.START_REASON
, HR_CONTRACT_API.GET_MEANING(PCF1.START_REASON
, 'CONTRACT_START_REASON')
, PCF1.END_REASON
, HR_CONTRACT_API.GET_MEANING(PCF1.END_REASON
, 'CONTRACT_END_REASON')
, PCF1.NUMBER_OF_EXTENSIONS
, PCF1.EXTENSION_REASON
, PCF1.EXTENSION_PERIOD
, PCF1.EXTENSION_PERIOD_UNITS
, HR_CONTRACT_API.GET_MEANING(PCF1.EXTENSION_PERIOD_UNITS
, 'QUALIFYING_UNITS')
, PCF1.CTR_INFORMATION_CATEGORY
, PCF1.CTR_INFORMATION1
, PCF1.CTR_INFORMATION2
, PCF1.CTR_INFORMATION3
, PCF1.CTR_INFORMATION4
, PCF1.CTR_INFORMATION5
, PCF1.CTR_INFORMATION6
, PCF1.CTR_INFORMATION7
, PCF1.CTR_INFORMATION8
, PCF1.CTR_INFORMATION9
, PCF1.CTR_INFORMATION10
, PCF1.CTR_INFORMATION11
, PCF1.CTR_INFORMATION12
, PCF1.CTR_INFORMATION13
, PCF1.CTR_INFORMATION14
, PCF1.CTR_INFORMATION15
, PCF1.CTR_INFORMATION16
, PCF1.CTR_INFORMATION17
, PCF1.CTR_INFORMATION18
, PCF1.CTR_INFORMATION19
, PCF1.CTR_INFORMATION20
, PCF1.ATTRIBUTE_CATEGORY
, PCF1.ATTRIBUTE1
, PCF1.ATTRIBUTE2
, PCF1.ATTRIBUTE3
, PCF1.ATTRIBUTE4
, PCF1.ATTRIBUTE5
, PCF1.ATTRIBUTE6
, PCF1.ATTRIBUTE7
, PCF1.ATTRIBUTE8
, PCF1.ATTRIBUTE9
, PCF1.ATTRIBUTE10
, PCF1.ATTRIBUTE11
, PCF1.ATTRIBUTE12
, PCF1.ATTRIBUTE13
, PCF1.ATTRIBUTE14
, PCF1.ATTRIBUTE15
, PCF1.ATTRIBUTE16
, PCF1.ATTRIBUTE17
, PCF1.ATTRIBUTE18
, PCF1.ATTRIBUTE19
, PCF1.ATTRIBUTE20
, PCF1.LAST_UPDATE_DATE
, PCF1.LAST_UPDATED_BY
, PCF1.LAST_UPDATE_LOGIN
, PCF1.CREATED_BY
, PCF1.CREATION_DATE
FROM PER_CONTRACTS_F PCF1
, FND_SESSIONS FS
WHERE FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN PCF1.EFFECTIVE_START_DATE
AND PCF1.EFFECTIVE_END_DATE