5795: l_vac_grade_id per_all_assignments_f.grade_id%TYPE;
5796: --
5797: cursor csr_valid_grade is
5798: select business_group_id
5799: from per_grades
5800: where grade_id = p_grade_id
5801: and p_validation_start_date
5802: between date_from and nvl(date_to, hr_api.g_eot);
5803: --
5861: --
5862: if p_grade_id is not null then
5863: --
5864: -- Check that the grade exists between date from and date to in
5865: -- PER_GRADES.
5866: --
5867: open csr_valid_grade;
5868: fetch csr_valid_grade into l_business_group_id;
5869: if csr_valid_grade%notfound then