DBA Data[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on PER_GRADES

Line 5799: from per_grades

5795: l_vac_grade_id per_all_assignments_f.grade_id%TYPE;
5796: --
5797: cursor csr_valid_grade is
5798: select business_group_id
5799: from per_grades
5800: where grade_id = p_grade_id
5801: and p_validation_start_date
5802: between date_from and nvl(date_to, hr_api.g_eot);
5803: --

Line 5865: -- PER_GRADES.

5861: --
5862: if p_grade_id is not null then
5863: --
5864: -- Check that the grade exists between date from and date to in
5865: -- PER_GRADES.
5866: --
5867: open csr_valid_grade;
5868: fetch csr_valid_grade into l_business_group_id;
5869: if csr_valid_grade%notfound then