APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on PER_GRADES

Line 2099: from per_grades_vl gra

2095: -- pabodla : mapping data
2096: --
2097: cursor c_get_mapping_name2(p_id in number,p_date in date) is
2098: select gra.name dsp_name
2099: from per_grades_vl gra
2100: where business_group_id = p_business_group_id
2101: and gra.grade_id = p_id
2102: and p_date between date_from and nvl(date_to, p_date) ;
2103: --

Line 2106: from per_grades

2102: and p_date between date_from and nvl(date_to, p_date) ;
2103: --
2104: cursor c_grade_start_date(c_grade_id number) is
2105: select date_from
2106: from per_grades
2107: where grade_id = c_grade_id;
2108:
2109: l_grade_start_date per_grades.date_from%type;
2110: ---------------------------------------------------------------

Line 2109: l_grade_start_date per_grades.date_from%type;

2105: select date_from
2106: from per_grades
2107: where grade_id = c_grade_id;
2108:
2109: l_grade_start_date per_grades.date_from%type;
2110: ---------------------------------------------------------------
2111: -- END OF BEN_ELIG_GRD_PRTE_F ----------------------
2112: ---------------------------------------------------------------
2113: ---------------------------------------------------------------

Line 3116: from per_grades_vl a,

3112: -- 9999 resolve the sql
3113: cursor c_get_mapping_name12(p_id in number,p_date in date) is
3114: select a.name grade
3115: , d.step_id
3116: from per_grades_vl a,
3117: per_parent_spines b,
3118: per_spinal_points c,
3119: per_spinal_point_steps_f d,
3120: per_grade_spines e