264: where bde1.job_id = p_job_id
265: and bde1.job_id is not null;
266: --
267: cursor csr_vacancy is select null
268: from per_vacancies vac
269: where vac.job_id = p_job_id
270: and vac.job_id is not null;
271: --
272: cursor csr_link is select null
293: --
294: -- Check there are no values in per_valid_grades, per_job_requirements,
295: -- per_job_evaluations, per_career_path_elements (check on parent and
296: -- subordinate id), hr_all_positions_f, per_budget_elements,
297: -- PER_all_assignments, per_vacancies_f, per_element_links_f
298: --
299: --
300: --
301: open csr_position;