APPS.PER_CAGR_EVALUATION_PKG dependencies on PER_GRADE_SPINES_F

Line 808: FROM per_grade_spines_f gs

804: -- criteria eligibility determination in addition to satisfying eligibility profile.
805:
806: CURSOR csr_grade_spines IS
807: SELECT gs.grade_id
808: FROM per_grade_spines_f gs
809: WHERE gs.grade_spine_id = p_grade_spine_id
810: AND p_effective_date between gs.effective_start_date and gs.effective_end_date;
811:
812: l_proc constant VARCHAR2(60) := g_pkg || '.get_PYS_grade_id';

Line 813: l_grade_id per_grade_spines_f.grade_id%TYPE := NULL;

809: WHERE gs.grade_spine_id = p_grade_spine_id
810: AND p_effective_date between gs.effective_start_date and gs.effective_end_date;
811:
812: l_proc constant VARCHAR2(60) := g_pkg || '.get_PYS_grade_id';
813: l_grade_id per_grade_spines_f.grade_id%TYPE := NULL;
814:
815: BEGIN
816:
817: hr_utility.set_location('Entering:'||l_proc, 10);