APPS.PQH_GSP_UTILITY dependencies on BEN_PLIP_F

Line 86: ben_plip_f bplip,

82: from
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

Line 142: ben_plip_f bplip,

138: from
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

Line 3250: Ben_Plip_F Plip,

3246: Cursor csr_pgm_detials(l_grade_id IN Number, l_rate IN Varchar, l_currency IN Varchar) Is
3247: Select Pgm.ACTY_REF_PERD_CD, -- Rate
3248: Pgm.Pgm_uom -- Currency
3249: From Ben_Pl_f Pl,
3250: Ben_Plip_F Plip,
3251: Ben_Pgm_F Pgm
3252: Where Pl.MAPPING_TABLE_PK_ID = l_grade_Id
3253: and Pl.MAPPING_TABLE_NAME = 'PER_GRADES'
3254: and P_Effective_Date

Line 5221: from ben_plip_f

5217: and mapping_table_name = 'PER_GRADES';
5218: Cursor Csr_Pgm_id (p_pl_id IN NUMBER)
5219: is
5220: select pgm_id
5221: from ben_plip_f
5222: where pl_id = p_pl_id;
5223: Cursor Csr_Use_Points(p_pgm_id IN NUMBER)
5224: is
5225: select USE_PROG_POINTS_FLAG