APPS.BEN_MANAGE_OVERRIDE dependencies on BEN_PL_F

Line 147: from ben_pl_f pln,

143: pgm.effective_start_date and pgm.effective_end_date ;
144: -- check for shell plan
145: cursor c_flx_plan_exists is
146: select pln.pl_id,plip.plip_id,ptip.ptip_id
147: from ben_pl_f pln,
148: ben_plip_f plip,
149: ben_ptip_f ptip
150: where
151: plip.pgm_id = p_pgm_id

Line 171: from ben_pl_f pln,

167: and epe.comp_lvl_cd = 'PLANFC' );
168: --check for imputed income plan
169: cursor c_imp_plan_exists is
170: select pln.pl_id,plip.plip_id,ptip.ptip_id
171: from ben_pl_f pln,
172: ben_plip_f plip,
173: ben_ptip_f ptip
174: where
175: plip.pgm_id = p_pgm_id