View: PER_CONTRACTS

Product:	PER - Human Resources
Description:	Date-effective view.
Implementation/DBA Data:	APPS.PER_CONTRACTS

View Text

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

Columns