View: PER_CONTRACTS_D

Product:	PER - Human Resources
Description:	Used by DateTrack history
Implementation/DBA Data:	APPS.PER_CONTRACTS_D

View Text

SELECT PCF1.CONTRACT_ID
, PCF1.EFFECTIVE_START_DATE
, PCF1.EFFECTIVE_END_DATE
, PCF1.REFERENCE
, HR1.MEANING
, HR2.MEANING
, HR3.MEANING
, PCF1.DURATION
, HR4.MEANING
, PCF1.CONTRACTUAL_JOB_TITLE
, PCF1.PARTIES
, HR5.MEANING
, HR6.MEANING
, PCF1.NUMBER_OF_EXTENSIONS
, PCF1.EXTENSION_REASON
, PCF1.EXTENSION_PERIOD
, HR7.MEANING
, PCF1.LAST_UPDATE_DATE
, USR.USER_NAME
FROM PER_CONTRACTS_F PCF1
, FND_USER USR
, HR_LOOKUPS HR1
, HR_LOOKUPS HR2
, HR_LOOKUPS HR3
, HR_LOOKUPS HR4
, HR_LOOKUPS HR5
, HR_LOOKUPS HR6
, HR_LOOKUPS HR7
WHERE USR.USER_ID (+) = PCF1.LAST_UPDATED_BY
AND HR1.LOOKUP_TYPE (+) = 'CONTRACT_TYPE'
AND HR1.LOOKUP_CODE = PCF1.TYPE
AND HR2.LOOKUP_TYPE (+) = 'CONTRACT_STATUS'
AND HR2.LOOKUP_CODE (+) = PCF1.STATUS
AND HR3.LOOKUP_TYPE (+) = 'CONTRACT_STATUS_REASON'
AND HR3.LOOKUP_CODE (+) = PCF1.STATUS_REASON
AND HR4.LOOKUP_TYPE (+) = 'QUALIFYING_UNITS'
AND HR4.LOOKUP_CODE (+) = PCF1.DURATION_UNITS
AND HR5.LOOKUP_TYPE (+) = 'CONTRACT_START_REASON'
AND HR5.LOOKUP_CODE (+) = PCF1.START_REASON
AND HR6.LOOKUP_TYPE (+) = 'CONTRACT_END_REASON'
AND HR6.LOOKUP_CODE (+) = PCF1.END_REASON
AND HR7.LOOKUP_TYPE (+) = 'QUALIFYING_UNITS'
AND HR7.LOOKUP_CODE (+) = PCF1.EXTENSION_PERIOD_UNITS

Columns