View: HRFV_REC_ACT_BY_VACANCIES

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

View Text

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PRA.NAME RECRUITMENT_ACTIVITY_NAME
, VAC.NAME VACANCY_NAME
, PRA.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PRA.RECRUITMENT_ACTIVITY_ID RECRUITMENT_ACTIVITY_ID
, VAC.VACANCY_ID VACANCY_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_VACANCIES VAC
, PER_RECRUITMENT_ACTIVITY_FOR RAF
, PER_RECRUITMENT_ACTIVITIES PRA
WHERE PRA.RECRUITMENT_ACTIVITY_ID = RAF.RECRUITMENT_ACTIVITY_ID (+)
AND RAF.VACANCY_ID = VAC.VACANCY_ID(+)
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