1567: Select Step.Step_id, Step.Spinal_point_id, Step.Grade_spine_id
1568: From Ben_Oipl_F Oipl,
1569: Ben_pl_F Pl,
1570: Ben_Opt_F Opt,
1571: Per_Spinal_points point,
1572: Per_Grade_Spines_f GSpine,
1573: Per_Spinal_point_Steps_F Step
1574: Where Oipl.Oipl_id = P_Entity_Id
1575: and P_Effective_Date
2256: Return P_Currency_name;
2257: End;
2258:
2259: Function Get_SpinalPoint_Name
2260: (p_Point_id IN per_spinal_points.Spinal_Point_Id%TYPE)
2261:
2262: Return Varchar2 is
2263:
2264: Cursor POints is
2262: Return Varchar2 is
2263:
2264: Cursor POints is
2265: Select spinal_point
2266: from per_spinal_points
2267: Where Spinal_point_id = p_Point_id;
2268:
2269: P_Spinal_Point_name per_spinal_points.Spinal_Point%TYPE := NULL;
2270: begin
2265: Select spinal_point
2266: from per_spinal_points
2267: Where Spinal_point_id = p_Point_id;
2268:
2269: P_Spinal_Point_name per_spinal_points.Spinal_Point%TYPE := NULL;
2270: begin
2271:
2272: If p_Point_id is Not Null then
2273: open POints;