DBA Data[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on PER_VALID_GRADES

Line 6102: from per_valid_grades

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);

Line 6112: from per_valid_grades

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

Line 6185: -- PER_VALID_GRADES.

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