View: PER_CONTRACTS_X

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

View Text

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

Columns