APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on PER_GRADES_VL

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

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

Line 6799: from per_grades_vl grd

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

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

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