DBA Data[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on PER_GRADES

Line 5925: from per_grades

5921: l_vac_grade_id per_all_assignments_f.grade_id%TYPE;
5922: --
5923: cursor csr_valid_grade is
5924: select business_group_id
5925: from per_grades
5926: where grade_id = p_grade_id
5927: and p_validation_start_date
5928: between date_from and nvl(date_to, hr_api.g_eot);
5929: --

Line 5991: -- PER_GRADES.

5987: --
5988: if p_grade_id is not null then
5989: --
5990: -- Check that the grade exists between date from and date to in
5991: -- PER_GRADES.
5992: --
5993: open csr_valid_grade;
5994: fetch csr_valid_grade into l_business_group_id;
5995: if csr_valid_grade%notfound then