DBA Data[Home] [Help]

APPS.PER_RECRUITMENT_ACTIVITIES_PKG dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 342: per_recruitment_activity_for raf

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
346: AND (v.date_from > P_date_start