APPS.PER_VACANCIES_PKG dependencies on PER_RECRUITMENT_ACTIVITIES

Line 466: PER_RECRUITMENT_ACTIVITIES ACTS

462: -- are outside the vacancy dates.
463: CURSOR c_rec_act_chk IS
464: SELECT 1
465: FROM PER_RECRUITMENT_ACTIVITY_FOR F,
466: PER_RECRUITMENT_ACTIVITIES ACTS
467: WHERE F.VACANCY_ID = P_vacancy_id
468: AND F.RECRUITMENT_ACTIVITY_ID = ACTS.RECRUITMENT_ACTIVITY_ID
469: AND ( ACTS.DATE_START < P_vac_date_from
470: OR nvl(ACTS.DATE_END,p_end_of_time) > nvl(P_vac_date_to, P_end_of_time) ) ;