APPS.PQH_GSP_UTILITY dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 1676: From Per_Spinal_Point_Placements_F Plcmt,

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

Line 1712: l_Parent_Spine_id Per_Spinal_Point_Placements_F.Parent_Spine_Id%TYPE;

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

Line 4991: from per_spinal_point_placements_f sp

4987: and gs.parent_spine_id = p_pspine_id
4988: and gs.grade_id = p_grd_id
4989: and exists
4990: (select null
4991: from per_spinal_point_placements_f sp
4992: where sp.step_id = sps.step_id
4993: and (p_effective_date between effective_start_date AND effective_end_date-1
4994: or effective_start_date >= p_effective_date ));
4995:

Line 5798: From Per_Spinal_Point_Placements_F Plcmt,

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