[Home] [Help]
853: cursor c_comp_obj_name (p_prtt_enrt_rslt_id number) is
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(+)
1764: --8589355
1765: cursor c_get_opt_id(p_oipl_id number, p_rt_strt_dt date)
1766: is
1767: select oipl.opt_id
1768: from ben_oipl_f oipl
1769: where oipl.oipl_id = p_oipl_id
1770: and business_group_id = p_business_group_id
1771: and p_rt_strt_dt between oipl.effective_start_date and oipl.effective_end_date;
1772:
4479:
4480:
4481: Cursor c_oipl is
4482: select opt_id
4483: from ben_oipl_f
4484: where oipl_id = p_oipl_id
4485: and business_group_id = p_business_group_id
4486: and p_effective_date between EFFECTIVE_START_DATE
4487: AND EFFECTIVE_END_DATE;
4843: l_delink_interim c_delink_interim%rowtype ;
4844: --
4845: cursor oipl_ordr_num_c (p_oipl_id number) is
4846: select ordr_num
4847: from ben_oipl_f
4848: where oipl_id = p_oipl_id and
4849: business_group_id = p_business_group_id and
4850: p_effective_date between
4851: effective_start_date and effective_end_date
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
8407: cursor c_pl_opt_name is
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(+)