eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GSP_UTILITY dependencies on PER_SPINAL_POINT_STEPS_F

Line 1558: Per_Spinal_Point_Steps_F Steps

1554:
1555: Cursor Step is
1556: Select Steps.Step_Id, Steps.Spinal_point_id, Steps.Grade_spine_id
1557: From Per_Spinal_Point_Placements_F Plcmt,
1558: Per_Spinal_Point_Steps_F Steps
1559: Where Plcmt.ASSIGNMENT_ID = P_Entity_id
1560: and P_Effective_Date
1561: Between Plcmt.Effective_Start_Date and Plcmt.Effective_End_Date
1562: and Plcmt.Step_id = Steps.Step_Id

Line 1573: Per_Spinal_point_Steps_F Step

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

Line 1592: l_Point_id Per_Spinal_POint_Steps_f.Spinal_Point_Id%TYPE;

1588: and P_Effective_Date
1589: Between Step.Effective_Start_Date and Step.Effective_End_Date
1590: and Step.SPINAL_POINT_ID = Point.SPINAL_POINT_ID;
1591:
1592: l_Point_id Per_Spinal_POint_Steps_f.Spinal_Point_Id%TYPE;
1593: l_Parent_Spine_id Per_Spinal_Point_Placements_F.Parent_Spine_Id%TYPE;
1594: l_Step_Id Per_Spinal_POint_Steps_F.Step_Id%TYPE := NULL;
1595: l_Step_name Number(10) := NULL;
1596: begin

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

1590: and Step.SPINAL_POINT_ID = Point.SPINAL_POINT_ID;
1591:
1592: l_Point_id Per_Spinal_POint_Steps_f.Spinal_Point_Id%TYPE;
1593: l_Parent_Spine_id Per_Spinal_Point_Placements_F.Parent_Spine_Id%TYPE;
1594: l_Step_Id Per_Spinal_POint_Steps_F.Step_Id%TYPE := NULL;
1595: l_Step_name Number(10) := NULL;
1596: begin
1597:
1598: If P_Curr_Prop = 'CURR' then

Line 4865: from per_spinal_point_steps_f sps,

4861: cursor c1(p_pspine_id IN Number,
4862: p_grd_id IN NUMBER,
4863: p_effective_date IN DATE) is
4864: select 'x'
4865: from per_spinal_point_steps_f sps,
4866: per_grade_spines_f gs
4867: where gs.grade_spine_id = sps.grade_spine_id
4868: and gs.parent_spine_id = p_pspine_id
4869: and gs.grade_id = p_grd_id