APPS.PER_VACANCIES_PKG dependencies on PER_RECRUITMENT_ACTIVITY_FOR

Line 104: , PER_RECRUITMENT_ACTIVITY_FOR PRAF

100:
101: CURSOR c_check_ref_2 IS
102: SELECT PV.NAME
103: FROM PER_VACANCIES PV
104: , PER_RECRUITMENT_ACTIVITY_FOR PRAF
105: WHERE PRAF.VACANCY_ID = P_vacancy_id
106: AND PV.VACANCY_ID = P_vacancy_id ;
107:
108: --

Line 473: FROM PER_RECRUITMENT_ACTIVITY_FOR F,

469: -- using the given vacancy where either of its start/end dates
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

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