APPS.BEN_BIS_UTILS dependencies on BEN_PL_F

Line 35: from ben_pl_f pl

31: is
32: --
33: cursor c1 is
34: select name
35: from ben_pl_f pl
36: where pl_id = p_pl_id
37: and business_group_id = p_business_group_id
38: and p_effective_date between effective_start_date and effective_end_date;
39: --

Line 63: from ben_pl_f pl

59: is
60: --
61: cursor c1 is
62: select name
63: from ben_pl_f pl
64: where pl_id = p_pl_id
65: and p_effective_date between effective_start_date and effective_end_date;
66: --
67: ret_str varchar2(1500);

Line 180: from ben_pl_f pln,

176: is
177: --
178: cursor c1 is
179: select pgm.name|| ' - '|| pln.name
180: from ben_pl_f pln,
181: ben_pgm_f pgm,
182: ben_plip_f plip
183: where plip.plip_id = p_plip_id
184: and pgm.pgm_id = plip.pgm_id

Line 252: from ben_pl_f pln,

248: is
249: --
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

Line 287: from ben_pl_f pln,

283: is
284: --
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

Line 321: from ben_pl_f pln,

317: is
318: --
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,