APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PER_GRADES_VL

Line 6794: l_grade_name per_grades_vl.name%type := null;

6790: (
6791: p_grade_id in number
6792: ) return varchar2 is
6793:
6794: l_grade_name per_grades_vl.name%type := null;
6795:
6796: cursor c_grade_name is
6797: select grd.name
6798: from per_grades_vl grd

Line 6798: from per_grades_vl grd

6794: l_grade_name per_grades_vl.name%type := null;
6795:
6796: cursor c_grade_name is
6797: select grd.name
6798: from per_grades_vl grd
6799: where grd.grade_id = p_grade_id;
6800:
6801: begin
6802: open c_grade_name;

Line 7168: from per_grades_vl a, per_parent_spines b, per_spinal_points c,

7164: l_sp_clng_step_name varchar2(800) := null;
7165:
7166: cursor c_sp_clng_step_name is
7167: select a.name ||b.name ||c.spinal_point name
7168: from per_grades_vl a, per_parent_spines b, per_spinal_points c,
7169: per_spinal_point_steps_f d, per_grade_spines e
7170: where d.step_id = p_special_ceiling_step_id
7171: and d.spinal_point_id = c.spinal_point_id
7172: and d.grade_spine_id = e.grade_spine_id