APPS.BEN_ELECTION_INFORMATION dependencies on BEN_OPT_F

Line 773: ben_opt_f opt

769: select rtrim(substr(pln.name||' '||opt.name,1,60)) -- 4203714 rtrim to chop off the trailing spaces
770: from ben_prtt_enrt_rslt_f pen,
771: ben_pl_f pln,
772: ben_oipl_f oipl,
773: ben_opt_f opt
774: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
775: and pen.pl_id = pln.pl_id
776: and pen.oipl_id = oipl.oipl_id(+)
777: and nvl(oipl.opt_id,0) = opt.opt_id (+)

Line 4487: from ben_opt_f opt , ben_oipl_f oipl

4483: and pen.effective_end_date ;
4484:
4485: cursor c_wv_opt (p_oipl_id number ) is
4486: select opt.invk_wv_opt_flag
4487: from ben_opt_f opt , ben_oipl_f oipl
4488: where oipl.oipl_id = p_oipl_id
4489: and oipl.opt_id = opt.opt_id
4490: and oipl.business_group_id = p_business_group_id
4491: and p_effective_date between oipl.effective_start_date and oipl.effective_end_date

Line 7287: ben_opt_f opt

7283: select pln.name || ' '|| opt.name
7284: from ben_elig_per_elctbl_chc epe,
7285: ben_pl_f pln,
7286: ben_oipl_f oipl,
7287: ben_opt_f opt
7288: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
7289: and epe.pl_id = pln.pl_id
7290: and epe.oipl_id = oipl.oipl_id(+)
7291: and oipl.opt_id = opt.opt_id(+)