APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on PER_SPINAL_POINT_STEPS_F

Line 3119: per_spinal_point_steps_f d,

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
3121: where d.spinal_point_id = c.spinal_point_id
3122: and d.grade_spine_id = e.grade_spine_id
3123: and e.grade_id = a.grade_id

Line 3132: from per_spinal_point_steps_f

3128: --
3129:
3130: cursor c_step_start_date(c_step_id number) is
3131: select min(effective_start_date) effective_start_date
3132: from per_spinal_point_steps_f
3133: where step_id = c_step_id;
3134:
3135: l_step_start_date per_spinal_point_steps_f.effective_start_date%type;
3136: ---------------------------------------------------------------

Line 3135: l_step_start_date per_spinal_point_steps_f.effective_start_date%type;

3131: select min(effective_start_date) effective_start_date
3132: from per_spinal_point_steps_f
3133: where step_id = c_step_id;
3134:
3135: l_step_start_date per_spinal_point_steps_f.effective_start_date%type;
3136: ---------------------------------------------------------------
3137: -- END OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------
3138: ---------------------------------------------------------------
3139: ---------------------------------------------------------------