APPS.BEN_SSPNDD_ENROLLMENT dependencies on BEN_ENRT_RT

Line 2527: from ben_enrt_rt ecr

2523: cursor c_rt is
2524: select ecr.enrt_rt_id
2525: ,ecr.dflt_val
2526: ,ecr.ANN_DFLT_VAL
2527: from ben_enrt_rt ecr
2528: where ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2529: and ecr.business_group_id = p_business_group_id
2530: and ecr.entr_val_at_enrt_flag = 'Y'
2531: -- and ecr.prtt_rt_val_id is null -- Bug 5415757 - This clause prevented carry forward of rates for interim PEN

Line 2536: from ben_enrt_rt ecr

2532: union
2533: select ecr.enrt_rt_id
2534: ,ecr.dflt_val
2535: ,ecr.ANN_DFLT_VAL
2536: from ben_enrt_rt ecr
2537: ,ben_enrt_bnft enb
2538: where enb.enrt_bnft_id = ecr.enrt_bnft_id
2539: and ecr.business_group_id = p_business_group_id
2540: and enb.business_group_id = p_business_group_id

Line 3644: from ben_enrt_rt ecr

3640: ;
3641: cursor c_enrt(p_elig_per_elctbl_chc_id number,
3642: p_acty_base_rt_id number) is
3643: select ecr.*
3644: from ben_enrt_rt ecr
3645: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
3646: and acty_base_rt_id = p_acty_base_rt_id;
3647: l_enrt_rt c_enrt%rowtype;
3648:

Line 3770: from ben_enrt_rt

3766: --
3767: --
3768: cursor c_enrt_rt (p_prtt_rt_val_id number) is
3769: select decr_bnft_prvdr_pool_id
3770: from ben_enrt_rt
3771: where prtt_rt_val_id = p_prtt_rt_val_id;
3772: --
3773: --Bug 2958032 Get the benefit record of the unsuspended enrollment result
3774: --Update the enb to remove penid from the interim row