View: HRFV_RECRUITMENT_ACTIVITIES

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_RECRUITMENT_ACTIVITIES

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PRA.NAME RECRUITMENT_ACTIVITY_NAME
, PRA.DATE_START REC_ACTIVITY_DATE_START
, PRA.DATE_END REC_ACTIVITY_DATE_END
, PRA.DATE_CLOSING REC_ACTIVITY_DATE_CLOSING
, TO_NUMBER(PRA.PLANNED_COST) PLANNED_COST
, TO_NUMBER(PRA.ACTUAL_COST) ACTUAL_COST
, PRA.CURRENCY_CODE CURRENCY_CODE
, PRA.EXTERNAL_CONTACT EXTERNAL_CONTACT_NAME
, PRA.CONTACT_TELEPHONE_NUMBER EXT_CONTACT_TELEPHONE_NUMBER
, PP.FULL_NAME INTERNAL_CONTACT_NAME
, PP.EMPLOYEE_NUMBER INT_CONTACT_EMPLOYEE_NUMBER
, HL.MEANING RECRUITMENT_ACTIVITY_TYPE
, ORGT.NAME COORDINATING_ORGANIZATION
, '_DF:PER:PER_RECRUITMENT_ACTIVITIES:PRA'
, PRA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORGT.ORGANIZATION_ID COORDINATING_ORGANIZATION_ID
, PP.PERSON_ID INTERNAL_CONTACT_ID
, PRA.RECRUITMENT_ACTIVITY_ID RECRUITMENT_ACTIVITY_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_LOOKUPS HL
, PER_PEOPLE_F PP
, PER_RECRUITMENT_ACTIVITIES PRA
WHERE PRA.TYPE = HL.LOOKUP_CODE(+)
AND HL.LOOKUP_TYPE(+) = 'REC_TYPE'
AND PRA.INTERNAL_CONTACT_PERSON_ID = PP.PERSON_ID (+)
AND PRA.RUN_BY_ORGANIZATION_ID = ORGT.ORGANIZATION_ID (+)
AND ORGT.LANGUAGE (+) = USERENV('LANG')
AND TRUNC(SYSDATE) BETWEEN NVL(PP.EFFECTIVE_START_DATE
, TRUNC(SYSDATE))
AND NVL(PP.EFFECTIVE_END_DATE
, TRUNC(SYSDATE))
AND PRA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PRA.BUSINESS_GROUP_ID)
AND PRA.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns