[Home] [Help]
27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , per_all_vacancies pav
32: where pav.vacancy_id = p_vacancy_id
33: and pbg.business_group_id = pav.business_group_id;
34: --
35: -- Declare local variables
97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , per_all_vacancies pav
102: where pav.vacancy_id = p_vacancy_id
103: and pbg.business_group_id = pav.business_group_id;
104: --
105: -- Declare local variables
469: -- ----------------------------------------------------------------------------
470: -- {Start Of Comments}
471: --
472: -- Description:
473: -- This procedure checks if the vacancy_id exists in per_all_vacancies
474: --
475: --
476: -- Pre Conditions:
477: -- g_old_rec has been populated with details of the values currently in
498: l_proc varchar2(72) := g_package || 'chk_vacancy_id';
499: l_vacancy_id irc_agency_vacancies.vacancy_id%type;
500: --
501: --
502: -- Cursor to check that the vacancy_id exists in PER_ALL_VACANCIES
503: -- and is current at the p_start_date.
504: --
505: cursor csr_vacancy_id is
506: select vacancy_id
503: -- and is current at the p_start_date.
504: --
505: cursor csr_vacancy_id is
506: select vacancy_id
507: from per_all_vacancies
508: where vacancy_id = p_vacancy_id
509: and p_start_date between date_from and nvl(date_to,hr_api.g_eot);
510: --
511: Begin
517: ,p_argument => 'vacancy_id'
518: ,p_argument_value => p_vacancy_id
519: );
520: --
521: -- Check if the vacancy_id exists in PER_ALL_VACANCIES
522: -- and is current at the p_start_date.
523: --
524: open csr_vacancy_id;
525: fetch csr_vacancy_id into l_vacancy_id;