1139: where vg1.business_group_id + 0 = p_business_group_id
1140: and vg1.job_id = p_job_id;
1141: --
1142: cursor csr_requirement is select null
1143: from per_job_requirements jre1
1144: where jre1.job_id = p_job_id;
1145: --
1146: cursor csr_evaluation is select null
1147: from per_job_evaluations jev1
1187: l_proc varchar2(72) := g_package||'check_delete_record';
1188: --
1189: begin
1190: --
1191: -- Check there are no values in per_valid_grades, per_job_requirements,
1192: -- per_job_evaluations, per_career_path_elements (check on parent and
1193: -- subordinate id), hr_all_positions_f, per_budget_elements,
1194: -- PER_all_assignments, per_vacancies_f, per_element_links_f
1195: --