eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HRFV_REC_ACT_BY_VACANCIES

Source

View Text - Preformatted


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

View Text - HTML Formatted

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