APPS.BEN_ELECTION_INFORMATION dependencies on BEN_OIPL_F

Line 772: ben_oipl_f oipl,

768: cursor c_comp_obj_name (p_prtt_enrt_rslt_id number) is
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(+)

Line 3986: from ben_oipl_f

3982:
3983:
3984: Cursor c_oipl is
3985: select opt_id
3986: from ben_oipl_f
3987: where oipl_id = p_oipl_id
3988: and business_group_id = p_business_group_id
3989: and p_effective_date between EFFECTIVE_START_DATE
3990: AND EFFECTIVE_END_DATE;

Line 4349: from ben_oipl_f

4345: l_delink_interim c_delink_interim%rowtype ;
4346: --
4347: cursor oipl_ordr_num_c (p_oipl_id number) is
4348: select ordr_num
4349: from ben_oipl_f
4350: where oipl_id = p_oipl_id and
4351: business_group_id = p_business_group_id and
4352: p_effective_date between
4353: effective_start_date and effective_end_date

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 7286: ben_oipl_f oipl,

7282: cursor c_pl_opt_name is
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(+)