APPS.HR_PSF_BUS dependencies on PER_GRADES

Line 872: from per_grades

868: l_vac_grade_id hr_all_positions_f.entry_grade_id%TYPE;
869: --
870: cursor csr_valid_grade is
871: select business_group_id
872: from per_grades
873: where grade_id = p_entry_grade_id
874: and p_validation_start_date
875: between date_from and nvl(date_to, hr_api.g_eot);
876: --

Line 939: -- PER_GRADES.

935: --
936: if p_entry_grade_id is not null then
937: --
938: -- Check that the grade exists between date from and date to in
939: -- PER_GRADES.
940: --
941: open csr_valid_grade;
942: fetch csr_valid_grade into l_business_group_id;
943: if csr_valid_grade%notfound then

Line 1069: -- PER_GRADES.

1065: --
1066: if p_entry_grade_rule_id is not null then
1067: --
1068: -- Check that the grade exists between date from and date to in
1069: -- PER_GRADES.
1070: --
1071: open csr_valid_grade_rule;
1072: fetch csr_valid_grade_rule into l_business_group_id;
1073: if csr_valid_grade_rule%notfound then