APPS.PER_VACANCIES_PKG dependencies on PER_RECRUITMENT_ACTIVITIES

Line 474: PER_RECRUITMENT_ACTIVITIES ACTS

470: -- are outside the vacancy dates.
471: CURSOR c_rec_act_chk IS
472: SELECT 1
473: FROM PER_RECRUITMENT_ACTIVITY_FOR F,
474: PER_RECRUITMENT_ACTIVITIES ACTS
475: WHERE F.VACANCY_ID = P_vacancy_id
476: AND F.RECRUITMENT_ACTIVITY_ID = ACTS.RECRUITMENT_ACTIVITY_ID
477: AND ( ACTS.DATE_START < P_vac_date_from
478: OR nvl(ACTS.DATE_END,p_end_of_time) > nvl(P_vac_date_to, P_end_of_time) ) ;

Line 1438: from per_recruitment_activities pra, per_recruitment_activity_for praf

1434:
1435: --
1436: CURSOR c_get_irec_site_RA is
1437: select pra.recruitment_activity_id, pra.object_version_number
1438: from per_recruitment_activities pra, per_recruitment_activity_for praf
1439: where pra.recruitment_activity_id = praf.recruitment_activity_id
1440: and praf.vacancy_id = P_vacancy_id
1441: and pra.posting_content_id is not NULL
1442: and pra.recruiting_site_id is not NULL

Line 1501: FROM per_recruitment_activities pra, per_recruitment_activity_for praf

1497:
1498: --
1499: CURSOR c_per_vac_RA IS
1500: SELECT pra.recruitment_activity_id,pra.object_version_number
1501: FROM per_recruitment_activities pra, per_recruitment_activity_for praf
1502: WHERE pra.recruitment_activity_id = praf.recruitment_activity_id
1503: AND praf.vacancy_id = P_vacancy_id
1504: AND pra.recruitment_activity_id = P_recruitment_activity_id
1505: AND pra.posting_content_id is null