APPS.IRC_VCE_BUS dependencies on PER_ALL_VACANCIES

Line 33: , per_all_vacancies pav

29: --
30: cursor csr_sec_grp is
31: select pbg.security_group_id
32: from per_business_groups pbg
33: , per_all_vacancies pav
34: where pav.vacancy_id = p_vacancy_id
35: and pbg.business_group_id = pav.business_group_id;
36: --
37: --

Line 110: ,per_all_vacancies pav

106:
107: cursor csr_leg_code is
108: select pbg.legislation_code
109: from per_business_groups pbg
110: ,per_all_vacancies pav
111: where pav.vacancy_id = p_vacancy_id
112: and pbg.business_group_id = pav.business_group_id;
113: --
114: -- Declare local variables

Line 306: -- PER_ALL_VACANCIES

302: -- {Start Of Comments}
303: --
304: -- Description:
305: -- This procedure is used to ensure that vacancy id exists in
306: -- PER_ALL_VACANCIES
307: --
308: -- Pre Conditions:
309: --
310: -- In Arguments:

Line 332: select null from per_all_vacancies pav where pav.vacancy_id = p_vacancy_id

328: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
329: l_vacancy_id varchar2(1);
330: --
331: cursor csr_vacancy_id is
332: select null from per_all_vacancies pav where pav.vacancy_id = p_vacancy_id
333: and p_effective_date < NVL(pav.date_to,hr_api.g_eot);
334: --
335: begin
336: hr_utility.set_location('Entering:'||l_proc,10);

Line 343: -- Checks that vacancy_id exists in PER_ALL_VACANCIES.

339: (p_api_name => l_proc
340: ,p_argument => 'vacancy_id'
341: ,p_argument_value => p_vacancy_id
342: );
343: -- Checks that vacancy_id exists in PER_ALL_VACANCIES.
344: hr_utility.set_location(l_proc,15);
345: open csr_vacancy_id;
346: fetch csr_vacancy_id into l_vacancy_id;
347: if csr_vacancy_id%NOTFOUND then