VIEW: APPS.PER_CONTRACTS_X

Source

View Text - Preformatted

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

View Text - HTML Formatted

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