[Home] [Help]
2669: cursor c_rt is
2670: select ecr.enrt_rt_id
2671: ,ecr.dflt_val
2672: ,ecr.ANN_DFLT_VAL
2673: from ben_enrt_rt ecr
2674: where ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2675: and ecr.business_group_id = p_business_group_id
2676: and ecr.entr_val_at_enrt_flag = 'Y'
2677: -- and ecr.prtt_rt_val_id is null -- Bug 5415757 - This clause prevented carry forward of rates for interim PEN
2678: union
2679: select ecr.enrt_rt_id
2680: ,ecr.dflt_val
2681: ,ecr.ANN_DFLT_VAL
2682: from ben_enrt_rt ecr
2683: ,ben_enrt_bnft enb
2684: where enb.enrt_bnft_id = ecr.enrt_bnft_id
2685: and ecr.business_group_id = p_business_group_id
2686: and enb.business_group_id = p_business_group_id
3793:
3794: l_fonm_check c_fonm_check%rowtype;
3795: cursor c_get_enrt_rt(p_elig_per_elctbl_chc_id number) is
3796: select ecr.*
3797: from ben_enrt_rt ecr
3798: where ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
3799: and ecr.business_group_id = p_business_group_id
3800: union
3801: select ecr.*
3798: where ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
3799: and ecr.business_group_id = p_business_group_id
3800: union
3801: select ecr.*
3802: from ben_enrt_rt ecr
3803: ,ben_enrt_bnft enb
3804: where enb.enrt_bnft_id = ecr.enrt_bnft_id
3805: and ecr.business_group_id = p_business_group_id
3806: and enb.business_group_id = p_business_group_id
3809: ----Bug 7557403
3810: cursor c_enrt(p_elig_per_elctbl_chc_id number,
3811: p_acty_base_rt_id number) is
3812: select ecr.*
3813: from ben_enrt_rt ecr
3814: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
3815: and acty_base_rt_id = p_acty_base_rt_id;
3816: l_enrt_rt c_enrt%rowtype;
3817:
3935: --
3936: --
3937: cursor c_enrt_rt (p_prtt_rt_val_id number) is
3938: select decr_bnft_prvdr_pool_id
3939: from ben_enrt_rt
3940: where prtt_rt_val_id = p_prtt_rt_val_id;
3941: --
3942: --Bug 2958032 Get the benefit record of the unsuspended enrollment result
3943: --Update the enb to remove penid from the interim row
4260: --update the enrt rt table with the new rt start date
4261: /* open c_get_enrt_rt(l_elig_per_elctbl_chc_id);
4262: fetch c_get_enrt_rt into l_get_enrt_rt;
4263: if c_get_enrt_rt%found then
4264: update ben_enrt_rt
4265: set rt_strt_dt = l_unsusp_cvg_start_date
4266: where enrt_rt_id = l_get_enrt_rt.enrt_rt_id;
4267: end if;
4268: close c_get_enrt_rt;*/
4267: end if;
4268: close c_get_enrt_rt;*/
4269: for l_get_rt in c_get_enrt_rt(l_elig_per_elctbl_chc_id) loop
4270: hr_utility.set_location('l_get_rt.enrt_rt_id : '||l_get_rt.enrt_rt_id,777);
4271: update ben_enrt_rt
4272: set rt_strt_dt = l_unsusp_cvg_start_date
4273: where enrt_rt_id = l_get_rt.enrt_rt_id;
4274: end loop;
4275: ----------Bug 8420062