APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_VACANCIES

Line 261: from per_vacancies pv

257: -- vacancies cursor
258: --
259: cursor vacancies is
260: select rowid
261: from per_vacancies pv
262: where (pv.business_group_id = p_business_group_id OR
263: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
264: and pv.recruiter_id = p_person_id
265: and pv.date_from >= p_effective_date

Line 526: from per_vacancies pv

522: -- vacancies cursor
523: --
524: cursor vacancies is
525: select rowid
526: from per_vacancies pv
527: where (pv.business_group_id = p_business_group_id OR
528: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
529: and pv.recruiter_id = p_person_id
530: and pv.date_from >= p_primary_date

Line 897: from per_vacancies pv

893: -- vacancies cursor
894: --
895: cursor vacancy is
896: select rowid
897: from per_vacancies pv
898: where (pv.business_group_id = p_business_group_id OR
899: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
900: and pv.recruiter_id = p_person_id
901: and pv.date_from >= p_primary_date;

Line 2149: from per_vacancies pv

2145: -- vacancies cursor
2146: --
2147: cursor vacancies is
2148: select rowid
2149: from per_vacancies pv
2150: where (pv.business_group_id = p_business_group_id OR
2151: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
2152: and pv.recruiter_id = p_person_id
2153: and pv.date_from >= p_date_start;

Line 4074: FROM per_vacancies pv

4070: -- vacancies cursor
4071: --
4072: CURSOR csr_vacancy IS
4073: SELECT ROWID
4074: FROM per_vacancies pv
4075: WHERE (pv.business_group_id = p_business_group_id OR
4076: NVL(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4077: AND pv.recruiter_id = p_person_id
4078: AND pv.date_from >= l_effective_date;

Line 4597: FROM per_vacancies pv

4593: -- vacancies cursor
4594: --
4595: CURSOR csr_vacancies IS
4596: SELECT ROWID
4597: FROM per_vacancies pv
4598: WHERE (pv.business_group_id = p_business_group_id OR
4599: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
4600: AND pv.recruiter_id = p_person_id
4601: AND pv.date_from >= p_date_start;