APPS.BEN_BIS_UTILS dependencies on BEN_OPT_F

Line 121: from ben_opt_f

117: is
118: --
119: cursor c1 is
120: select name
121: from ben_opt_f
122: where opt_id = p_opt_id
123: and business_group_id = p_business_group_id
124: and p_effective_date between effective_start_date and effective_end_date;
125: --

Line 151: from ben_opt_f

147: is
148: --
149: cursor c1 is
150: select name
151: from ben_opt_f
152: where opt_id = p_opt_id
153: and p_effective_date between effective_start_date and effective_end_date;
154: --
155: ret_str varchar2(1500);

Line 253: ben_opt_f opt,

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
257: and pln.pl_id = oipl.pl_id

Line 288: ben_opt_f opt,

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
292: and pln.pl_id = oipl.pl_id

Line 322: ben_opt_f opt,

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,
326: ben_pgm_f pgm