View: PER_RECRUITMENT_ACTIVITIES_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_RECRUITMENT_ACTIVITIES_V

View Text

SELECT RCA.ROWID ROW_ID
, RCA.RECRUITMENT_ACTIVITY_ID
, RCA.BUSINESS_GROUP_ID
, RCA.AUTHORISING_PERSON_ID
, PP1.FULL_NAME AUTH_PERSON_NAME
, PP1.EMPLOYEE_NUMBER AUTH_EMP_NUMBER
, RCA.RUN_BY_ORGANIZATION_ID
, HOUTL.NAME ORG_RUN_BY_NAME
, HL.MEANING D_TYPE
, RCA.INTERNAL_CONTACT_PERSON_ID
, PP2.FULL_NAME INT_CONTACT_NAME
, PP2.EMPLOYEE_NUMBER INT_CONT_EMP_NUM
, RCA.PARENT_RECRUITMENT_ACTIVITY_ID
, RCA1.NAME PARENT_REC_NAME
, HL2.MEANING D_PARENT_REC_TYPE
, RCA1.TYPE C_PARENT_REC_TYPE_CODE
, RCA.CURRENCY_CODE
, RCA.DATE_START
, RCA.NAME
, RCA.ACTUAL_COST
, HR_CHKFMT.CHANGEFORMAT( RCA.ACTUAL_COST
, 'M'
, RCA.CURRENCY_CODE) D_ACTUAL_COST
, RCA.COMMENTS
, RCA.CONTACT_TELEPHONE_NUMBER
, RCA.DATE_CLOSING
, RCA.DATE_END
, RCA.EXTERNAL_CONTACT
, RCA.PLANNED_COST
, HR_CHKFMT.CHANGEFORMAT( RCA.PLANNED_COST
, 'M'
, RCA.CURRENCY_CODE) D_PLANNED_COST
, RCA.TYPE
, RCA.REQUEST_ID
, RCA.PROGRAM_APPLICATION_ID
, RCA.PROGRAM_ID
, RCA.PROGRAM_UPDATE_DATE
, RCA.ATTRIBUTE_CATEGORY
, RCA.ATTRIBUTE1
, RCA.ATTRIBUTE2
, RCA.ATTRIBUTE3
, RCA.ATTRIBUTE4
, RCA.ATTRIBUTE5
, RCA.ATTRIBUTE6
, RCA.ATTRIBUTE7
, RCA.ATTRIBUTE8
, RCA.ATTRIBUTE9
, RCA.ATTRIBUTE10
, RCA.ATTRIBUTE11
, RCA.ATTRIBUTE12
, RCA.ATTRIBUTE13
, RCA.ATTRIBUTE14
, RCA.ATTRIBUTE15
, RCA.ATTRIBUTE16
, RCA.ATTRIBUTE17
, RCA.ATTRIBUTE18
, RCA.ATTRIBUTE19
, RCA.ATTRIBUTE20
, RCA.LAST_UPDATE_DATE
, RCA.LAST_UPDATED_BY
, RCA.LAST_UPDATE_LOGIN
, RCA.CREATED_BY
, RCA.CREATION_DATE
FROM PER_RECRUITMENT_ACTIVITIES RCA
, PER_ALL_PEOPLE_F PP1
, PER_ALL_PEOPLE_F PP2
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL
, PER_RECRUITMENT_ACTIVITIES RCA1
, HR_LOOKUPS HL
, HR_LOOKUPS HL2
WHERE RCA.AUTHORISING_PERSON_ID = PP1.PERSON_ID(+)
AND RCA.INTERNAL_CONTACT_PERSON_ID = PP2.PERSON_ID(+)
AND RCA.TYPE = HL.LOOKUP_CODE(+)
AND HL.LOOKUP_TYPE(+) = 'REC_TYPE'
AND RCA1.TYPE = HL2.LOOKUP_CODE(+)
AND HL2.LOOKUP_TYPE(+) = 'REC_TYPE'
AND RCA.RUN_BY_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND RCA.PARENT_RECRUITMENT_ACTIVITY_ID = RCA1.RECRUITMENT_ACTIVITY_ID(+)
AND (PP1.PERSON_ID IS NULL OR (PP1.EFFECTIVE_START_DATE <= RCA.DATE_START
AND PP1.EFFECTIVE_END_DATE >= RCA.DATE_START))
AND (PP2.PERSON_ID IS NULL OR (PP2.EFFECTIVE_START_DATE <= RCA.DATE_START
AND PP2.EFFECTIVE_END_DATE >= RCA.DATE_START))
AND HOU.ORGANIZATION_ID = HOUTL.ORGANIZATION_ID (+)
AND DECODE (HOUTL.ORGANIZATION_ID
, NULL
, '1'
, HOUTL.LANGUAGE) = DECODE(HOUTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))

Columns