APPS.PQH_GSP_UTILITY dependencies on PER_SPINAL_POINTS

Line 1690: Per_Spinal_points point,

1686: Select Step.Step_id, Step.Spinal_point_id, Step.Grade_spine_id
1687: From Ben_Oipl_F Oipl,
1688: Ben_pl_F Pl,
1689: Ben_Opt_F Opt,
1690: Per_Spinal_points point,
1691: Per_Grade_Spines_f GSpine,
1692: Per_Spinal_point_Steps_F Step
1693: Where Oipl.Oipl_id = P_Entity_Id
1694: and P_Effective_Date

Line 2379: (p_Point_id IN per_spinal_points.Spinal_Point_Id%TYPE)

2375: Return P_Currency_name;
2376: End;
2377:
2378: Function Get_SpinalPoint_Name
2379: (p_Point_id IN per_spinal_points.Spinal_Point_Id%TYPE)
2380:
2381: Return Varchar2 is
2382:
2383: Cursor POints is

Line 2385: from per_spinal_points

2381: Return Varchar2 is
2382:
2383: Cursor POints is
2384: Select spinal_point
2385: from per_spinal_points
2386: Where Spinal_point_id = p_Point_id;
2387:
2388: P_Spinal_Point_name per_spinal_points.Spinal_Point%TYPE := NULL;
2389: begin

Line 2388: P_Spinal_Point_name per_spinal_points.Spinal_Point%TYPE := NULL;

2384: Select spinal_point
2385: from per_spinal_points
2386: Where Spinal_point_id = p_Point_id;
2387:
2388: P_Spinal_Point_name per_spinal_points.Spinal_Point%TYPE := NULL;
2389: begin
2390:
2391: If p_Point_id is Not Null then
2392: open POints;