APPS.PER_VAC_BUS dependencies on PER_VALID_GRADES

Line 925: from per_valid_grades

921: l_inv_pos_grade_warning boolean := false;
922: --
923: cursor csr_valid_pos_val_grd is
924: select null
925: from per_valid_grades
926: where position_id = p_position_id
927: and grade_id = p_grade_id
928: and p_effective_date
929: between date_from

Line 1281: from per_valid_grades

1277: l_inv_job_grade_warning boolean := false;
1278: --
1279: cursor csr_val_job_grade is
1280: select null
1281: from per_valid_grades
1282: where job_id = p_job_id
1283: and grade_id = p_grade_id
1284: and p_effective_date
1285: between date_from

Line 1323: -- PER_VALID_GRADES.

1319: --
1320: if p_job_id is not null and p_grade_id is not null then
1321: --
1322: -- Check if the job and grade exists date effectively in
1323: -- PER_VALID_GRADES.
1324: --
1325: open csr_val_job_grade;
1326: fetch csr_val_job_grade into l_exists;
1327: if csr_val_job_grade%notfound then