APPS.PER_ASG_BUS1 dependencies on PER_VALID_GRADES

Line 6229: from per_valid_grades

6225: -- the valid grades for the selected JOB.
6226: --
6227: cursor csr_val_job_grade_exists is
6228: select null
6229: from per_valid_grades
6230: where job_id = p_job_id
6231: and p_validation_start_date
6232: between date_from
6233: and nvl(date_to, hr_api.g_eot);

Line 6239: from per_valid_grades

6235: -- Bug 3566686 Ends Here
6236: --
6237: cursor csr_val_job_grade is
6238: select null
6239: from per_valid_grades
6240: where job_id = p_job_id
6241: and grade_id = p_grade_id
6242: and p_validation_start_date
6243: between date_from

Line 6320: -- PER_VALID_GRADES.

6316: --
6317: if p_job_id is not null and p_grade_id is not null then
6318: --
6319: -- Check if the job and grade exists date effectively in
6320: -- PER_VALID_GRADES.
6321: --
6322: -- Bug 3566686 Starts Here
6323: -- Description : The first if condition checks whether there are any
6324: -- grades defined as the valid grades for the selected