APPS.PQH_GSP_UTILITY dependencies on PER_GRADE_SPINES_F

Line 87: per_grade_spines_f pgs,

83: ben_pgm_f bpgm,
84: ben_pl_f bp,
85: BEN_PL_TYP_F bpt,
86: ben_plip_f bplip,
87: per_grade_spines_f pgs,
88: per_grades pg
89: where
90: bp.pl_typ_id = bpt.pl_typ_id
91: and bpt.OPT_TYP_CD = 'GSP'

Line 143: per_grade_spines_f pgs,

139: ben_pgm_f bpgm,
140: ben_pl_f bp,
141: BEN_PL_TYP_F bpt,
142: ben_plip_f bplip,
143: per_grade_spines_f pgs,
144: per_grades pg,
145: pay_rates pr,
146: per_parent_spines pps
147: where

Line 1691: Per_Grade_Spines_f GSpine,

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

Line 4722: FROM per_grade_spines_f

4718:
4719: CURSOR csr_gspine_id (p_grade_id IN NUMBER)
4720: IS
4721: SELECT grade_spine_id
4722: FROM per_grade_spines_f
4723: WHERE p_effective_date BETWEEN effective_start_date
4724: AND effective_end_date
4725: AND grade_id = p_grade_id;
4726: BEGIN

Line 4985: per_grade_spines_f gs

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

Line 5210: from per_grade_spines_f

5206: l_status varchar2(1) := 'N';
5207: cursor csr_grade_id
5208: is
5209: select grade_id
5210: from per_grade_spines_f
5211: where parent_spine_id = p_parent_spine_id;
5212: Cursor Csr_Plan_id (p_grade_id IN NUMBER)
5213: is
5214: select pl_id