APPS.BEN_PLN_CACHE dependencies on BEN_PLIP_F

Line 64: ben_plip_f plp

60: pln.trk_inelig_per_flag
61: from ben_ptip_f ctp,
62: ben_pl_f pln,
63: ben_pl_typ_f ptp,
64: ben_plip_f plp
65: -- ben_popl_yr_perd cpy,
66: -- ben_yr_perd yrp
67: where
68: /* Hint joins */

Line 127: from ben_plip_f cpp,

123: /* Make sure that plan being linked to covers all the programs that may
124: or may not have been stated by the user. Also link in the benefits
125: reporting group. */
126: and (exists (select null
127: from ben_plip_f cpp,
128: ben_rptg_grp bnr,
129: ben_popl_rptg_grp rgr
130: where cpp.pgm_id = c_pgm_id
131: and cpp.pl_id = pln.pl_id

Line 262: ben_plip_f plp

258: pln.trk_inelig_per_flag
259: from ben_ptip_f ctp,
260: ben_pl_f pln,
261: ben_pl_typ_f ptp,
262: ben_plip_f plp
263: -- ben_popl_yr_perd cpy,
264: -- ben_yr_perd yrp
265: where
266: /* Hint joins */