6098: -- the valid grades for the selected JOB.
6099: --
6100: cursor csr_val_job_grade_exists is
6101: select null
6102: from per_valid_grades
6103: where job_id = p_job_id
6104: and p_validation_start_date
6105: between date_from
6106: and nvl(date_to, hr_api.g_eot);
6108: -- Bug 3566686 Ends Here
6109: --
6110: cursor csr_val_job_grade is
6111: select null
6112: from per_valid_grades
6113: where job_id = p_job_id
6114: and grade_id = p_grade_id
6115: and p_validation_start_date
6116: between date_from
6181: --
6182: if p_job_id is not null and p_grade_id is not null then
6183: --
6184: -- Check if the job and grade exists date effectively in
6185: -- PER_VALID_GRADES.
6186: --
6187: -- Bug 3566686 Starts Here
6188: -- Description : The first if condition checks whether there are any
6189: -- grades defined as the valid grades for the selected