829: l_dummy number;
830: --
831: cursor csr_vacs(p_vacancy_id number) is
832: select 1
833: from per_all_vacancies vac
834: where vac.vacancy_id=p_vacancy_id
835: and vac.number_of_openings <
836: (select count(distinct assignment_id)
837: from per_all_assignments_f asg
1707: l_primary_cag_rec per_cagr_grades_def%rowtype;
1708: --
1709: cursor csr_vacs(p_vacancy_id number) is
1710: select 1
1711: from per_all_vacancies vac
1712: where vac.vacancy_id=p_vacancy_id
1713: and vac.number_of_openings <
1714: (select count(distinct assignment_id)
1715: from per_all_assignments_f asg