APPS.PQH_GSP_UTILITY dependencies on PER_GRADE_SPINES_F

Line 1572: Per_Grade_Spines_f GSpine,

1568: From Ben_Oipl_F Oipl,
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

Line 4603: FROM per_grade_spines_f

4599:
4600: CURSOR csr_gspine_id (p_grade_id IN NUMBER)
4601: IS
4602: SELECT grade_spine_id
4603: FROM per_grade_spines_f
4604: WHERE p_effective_date BETWEEN effective_start_date
4605: AND effective_end_date
4606: AND grade_id = p_grade_id;
4607: BEGIN

Line 4866: per_grade_spines_f gs

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
4870: and exists

Line 5091: from per_grade_spines_f

5087: l_status varchar2(1) := 'N';
5088: cursor csr_grade_id
5089: is
5090: select grade_id
5091: from per_grade_spines_f
5092: where parent_spine_id = p_parent_spine_id;
5093: Cursor Csr_Plan_id (p_grade_id IN NUMBER)
5094: is
5095: select pl_id