DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on PER_GRADES_VL

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 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