DBA Data[Home] [Help]

APPS.PQH_GSP_UTILITY dependencies on BEN_PL_F

Line 1569: Ben_pl_F Pl,

1565:
1566: Cursor PropStep Is
1567: Select Step.Step_id, Step.Spinal_point_id, Step.Grade_spine_id
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

Line 3130: From Ben_Pl_f Pl,

3126:
3127: Cursor csr_pgm_detials(l_grade_id IN Number, l_rate IN Varchar, l_currency IN Varchar) Is
3128: Select Pgm.ACTY_REF_PERD_CD, -- Rate
3129: Pgm.Pgm_uom -- Currency
3130: From Ben_Pl_f Pl,
3131: Ben_Plip_F Plip,
3132: Ben_Pgm_F Pgm
3133: Where Pl.MAPPING_TABLE_PK_ID = l_grade_Id
3134: and Pl.MAPPING_TABLE_NAME = 'PER_GRADES'

Line 5096: from ben_pl_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
5096: from ben_pl_f
5097: where mapping_table_pk_id = p_grade_id
5098: and mapping_table_name = 'PER_GRADES';
5099: Cursor Csr_Pgm_id (p_pl_id IN NUMBER)
5100: is