APPS.BEN_BIS_UTILS dependencies on BEN_OIPL_F

Line 254: ben_oipl_f oipl

250: cursor c1 is
251: select pln.name|| ' - '|| opt.name
252: from ben_pl_f pln,
253: ben_opt_f opt,
254: ben_oipl_f oipl
255: where oipl.oipl_id = p_oipl_id
256: and opt.opt_id = oipl.opt_id
257: and pln.pl_id = oipl.pl_id
258: and oipl.business_group_id = p_business_group_id

Line 289: ben_oipl_f oipl

285: cursor c1 is
286: select pln.name|| ' - '|| opt.name
287: from ben_pl_f pln,
288: ben_opt_f opt,
289: ben_oipl_f oipl
290: where oipl.oipl_id = p_oipl_id
291: and opt.opt_id = oipl.opt_id
292: and pln.pl_id = oipl.pl_id
293: and p_effective_date between oipl.effective_start_date and oipl.effective_end_date

Line 323: ben_oipl_f oipl,

319: cursor c1 is
320: select pgm.name || ' - '|| pln.name|| ' - '|| opt.name
321: from ben_pl_f pln,
322: ben_opt_f opt,
323: ben_oipl_f oipl,
324: ben_oiplip_f oiplip,
325: ben_plip_f plip,
326: ben_pgm_f pgm
327: where oiplip.oiplip_id = p_oiplip_id