APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_VACANCIES

Line 93: from per_vacancies pv

89: -- vacancies cursor
90: --
91: cursor vacancies is
92: select rowid
93: from per_vacancies pv
94: where (pv.business_group_id = p_business_group_id OR
95: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
96: and pv.recruiter_id = p_person_id
97: and pv.date_from >= p_effective_date

Line 358: from per_vacancies pv

354: -- vacancies cursor
355: --
356: cursor vacancies is
357: select rowid
358: from per_vacancies pv
359: where (pv.business_group_id = p_business_group_id OR
360: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
361: and pv.recruiter_id = p_person_id
362: and pv.date_from >= p_primary_date

Line 714: from per_vacancies pv

710: -- vacancies cursor
711: --
712: cursor vacancy is
713: select rowid
714: from per_vacancies pv
715: where (pv.business_group_id = p_business_group_id OR
716: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
717: and pv.recruiter_id = p_person_id
718: and pv.date_from >= p_primary_date;

Line 1239: from per_vacancies pv

1235: -- vacancies cursor
1236: --
1237: cursor vacancies is
1238: select rowid
1239: from per_vacancies pv
1240: where (pv.business_group_id = p_business_group_id OR
1241: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
1242: and pv.recruiter_id = p_person_id
1243: and pv.date_from >= p_date_start;

Line 2896: FROM per_vacancies pv

2892: -- vacancies cursor
2893: --
2894: CURSOR csr_vacancy IS
2895: SELECT ROWID
2896: FROM per_vacancies pv
2897: WHERE (pv.business_group_id = p_business_group_id OR
2898: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2899: AND pv.recruiter_id = p_person_id
2900: AND pv.date_from >= l_effective_date;

Line 3370: FROM per_vacancies pv

3366: -- vacancies cursor
3367: --
3368: CURSOR csr_vacancies IS
3369: SELECT ROWID
3370: FROM per_vacancies pv
3371: WHERE (pv.business_group_id = p_business_group_id OR
3372: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
3373: AND pv.recruiter_id = p_person_id
3374: AND pv.date_from >= p_date_start;