APPS.BEN_ELECTION_INFORMATION dependencies on BEN_OPT_F

Line 858: ben_opt_f opt

854: select rtrim(substr(pln.name||' '||opt.name,1,60)) -- 4203714 rtrim to chop off the trailing spaces
855: from ben_prtt_enrt_rslt_f pen,
856: ben_pl_f pln,
857: ben_oipl_f oipl,
858: ben_opt_f opt
859: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
860: and pen.pl_id = pln.pl_id
861: and pen.oipl_id = oipl.oipl_id(+)
862: and nvl(oipl.opt_id,0) = opt.opt_id (+)

Line 5021: from ben_opt_f opt , ben_oipl_f oipl

5017: and pen.effective_end_date ;
5018:
5019: cursor c_wv_opt (p_oipl_id number ) is
5020: select opt.invk_wv_opt_flag
5021: from ben_opt_f opt , ben_oipl_f oipl
5022: where oipl.oipl_id = p_oipl_id
5023: and oipl.opt_id = opt.opt_id
5024: and oipl.business_group_id = p_business_group_id
5025: and p_effective_date between oipl.effective_start_date and oipl.effective_end_date

Line 8412: ben_opt_f opt

8408: select pln.name || ' '|| opt.name
8409: from ben_elig_per_elctbl_chc epe,
8410: ben_pl_f pln,
8411: ben_oipl_f oipl,
8412: ben_opt_f opt
8413: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
8414: and epe.pl_id = pln.pl_id
8415: and epe.oipl_id = oipl.oipl_id(+)
8416: and oipl.opt_id = opt.opt_id(+)