APPS.PQH_GSP_UTILITY dependencies on PER_SPINAL_POINT_STEPS_F

Line 1677: Per_Spinal_Point_Steps_F Steps

1673:
1674: Cursor Step is
1675: Select Steps.Step_Id, Steps.Spinal_point_id, Steps.Grade_spine_id
1676: From Per_Spinal_Point_Placements_F Plcmt,
1677: Per_Spinal_Point_Steps_F Steps
1678: Where Plcmt.ASSIGNMENT_ID = P_Entity_id
1679: and P_Effective_Date
1680: Between Plcmt.Effective_Start_Date and Plcmt.Effective_End_Date
1681: and Plcmt.Step_id = Steps.Step_Id

Line 1692: Per_Spinal_point_Steps_F Step

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
1695: Between OiPl.Effective_Start_Date and OiPl.Effective_End_Date
1696: and Pl.Pl_id = Oipl.Pl_Id

Line 1711: l_Point_id Per_Spinal_POint_Steps_f.Spinal_Point_Id%TYPE;

1707: and P_Effective_Date
1708: Between Step.Effective_Start_Date and Step.Effective_End_Date
1709: and Step.SPINAL_POINT_ID = Point.SPINAL_POINT_ID;
1710:
1711: l_Point_id Per_Spinal_POint_Steps_f.Spinal_Point_Id%TYPE;
1712: l_Parent_Spine_id Per_Spinal_Point_Placements_F.Parent_Spine_Id%TYPE;
1713: l_Step_Id Per_Spinal_POint_Steps_F.Step_Id%TYPE := NULL;
1714: l_Step_name Number(10) := NULL;
1715: begin

Line 1713: l_Step_Id Per_Spinal_POint_Steps_F.Step_Id%TYPE := NULL;

1709: and Step.SPINAL_POINT_ID = Point.SPINAL_POINT_ID;
1710:
1711: l_Point_id Per_Spinal_POint_Steps_f.Spinal_Point_Id%TYPE;
1712: l_Parent_Spine_id Per_Spinal_Point_Placements_F.Parent_Spine_Id%TYPE;
1713: l_Step_Id Per_Spinal_POint_Steps_F.Step_Id%TYPE := NULL;
1714: l_Step_name Number(10) := NULL;
1715: begin
1716:
1717: If P_Curr_Prop = 'CURR' then

Line 4984: from per_spinal_point_steps_f sps,

4980: cursor c1(p_pspine_id IN Number,
4981: p_grd_id IN NUMBER,
4982: p_effective_date IN DATE) is
4983: select 'x'
4984: from per_spinal_point_steps_f sps,
4985: per_grade_spines_f gs
4986: where gs.grade_spine_id = sps.grade_spine_id
4987: and gs.parent_spine_id = p_pspine_id
4988: and gs.grade_id = p_grd_id

Line 5799: Per_Spinal_Point_Steps_F Steps

5795:
5796: Cursor Step is
5797: Select Steps.spinal_point_id
5798: From Per_Spinal_Point_Placements_F Plcmt,
5799: Per_Spinal_Point_Steps_F Steps
5800: Where Plcmt.ASSIGNMENT_ID = P_Entity_id
5801: and P_Effective_Date
5802: Between Plcmt.Effective_Start_Date and Plcmt.Effective_End_Date
5803: and Plcmt.Step_id = Steps.Step_Id

Line 5808: l_Spinal_Point_Id Per_Spinal_POint_Steps_F.spinal_point_id%TYPE := NULL;

5804: and P_Effective_Date
5805: Between Steps.Effective_Start_Date and Steps.Effective_End_Date;
5806:
5807: l_proc constant varchar2(72):= g_package||'Get_current_rate_value';
5808: l_Spinal_Point_Id Per_Spinal_POint_Steps_F.spinal_point_id%TYPE := NULL;
5809: -- l_rate_value Number(10) := NULL;
5810: l_rate_value Number(10,2) := NULL; -- Fix for the bug#11934026
5811:
5812: begin