APPS.PQH_GSP_UTILITY dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 1557: From Per_Spinal_Point_Placements_F Plcmt,

1553: RETURN Number Is
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

Line 1593: l_Parent_Spine_id Per_Spinal_Point_Placements_F.Parent_Spine_Id%TYPE;

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
1597:

Line 4872: from per_spinal_point_placements_f sp

4868: and gs.parent_spine_id = p_pspine_id
4869: and gs.grade_id = p_grd_id
4870: and exists
4871: (select null
4872: from per_spinal_point_placements_f sp
4873: where sp.step_id = sps.step_id
4874: and (p_effective_date between effective_start_date AND effective_end_date-1
4875: or effective_start_date >= p_effective_date ));
4876: