DBA Data[Home] [Help]

APPS.PER_RECRUITMENT_ACTIVITIES_PKG dependencies on PER_VACANCIES

Line 341: FROM per_vacancies v,

337: P_rec_activity_id NUMBER) IS
338: --
339: CURSOR csr_vac_dates IS
340: SELECT raf.vacancy_id
341: FROM per_vacancies v,
342: per_recruitment_activity_for raf
343: WHERE raf.recruitment_activity_id = P_rec_activity_id
344: AND v.business_group_id + 0 = P_Business_Group_id
345: AND raf.vacancy_id = v.vacancy_id