DBA Data[Home] [Help]

APPS.PQH_GSP_UTILITY dependencies on BEN_PL_F

Line 84: ben_pl_f bp,

80: pg.name
81: ,bpgm.name
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

Line 140: ben_pl_f bp,

136: pg.name
137: ,bpgm.name
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,

Line 1688: Ben_pl_F Pl,

1684:
1685: Cursor PropStep Is
1686: Select Step.Step_id, Step.Spinal_point_id, Step.Grade_spine_id
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

Line 3249: From Ben_Pl_f Pl,

3245:
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'

Line 5215: from ben_pl_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
5215: from ben_pl_f
5216: where mapping_table_pk_id = p_grade_id
5217: and mapping_table_name = 'PER_GRADES';
5218: Cursor Csr_Pgm_id (p_pl_id IN NUMBER)
5219: is