[Home] [Help]
356: 25-Sep-2006 bmanyam 115.158 5557305 : Premium has to be recalculated everytime
357: for rates of type 'Multiple of Premium'
358: 3-nov-2006 nhunur 115.159 c_perfprv,c_perfprv_2 to handle non recurrring
359:
360: 1-Feb-2007 bmanyam 115.160 5748126: Update BEN_ENRT_RT with the
361: latest PRV_ID, which occurs before the LE_OCRD_DT
362: 23-Feb-2006 bmanyam 115.161 5898039: same as above. [ON or before LE_OCRD_DT]
363:
364: 22-Jan-2007 rtagarra 115.160 ICM Changes.
636: is
637: select enrt.mn_elcn_val,
638: enrt.mx_elcn_val,
639: enrt.incrmt_elcn_val
640: from ben_enrt_rt enrt
641: where (enrt.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
642: or enrt.enrt_bnft_id = p_enrt_bnft_id) and
643: enrt.acty_base_rt_id = p_acty_base_rt_id;
644: l_enrt_rt c_enrt_rt%rowtype;
4315: ecr.cmcd_acty_ref_perd_cd,
4316: enb.elig_per_elctbl_chc_id,
4317: ecr.acty_base_rt_id,
4318: ecr.business_group_id
4319: from ben_enrt_rt ecr,
4320: ben_enrt_bnft enb
4321: where enb.enrt_bnft_id = p_enrt_bnft_id
4322: and ecr.enrt_bnft_id = enb.enrt_bnft_id
4323: and ecr.acty_base_rt_id = p_acty_base_rt_id; --Bug 4143012 get the correct rate
4330: and abr.effective_end_date;
4331: --
4332: cursor c_rt_strt_dt(p_enrt_rt_id NUMBER) is
4333: select enr.rt_strt_dt
4334: from ben_enrt_rt enr
4335: where enrt_rt_id = p_enrt_rt_id;
4336: l_rt_strt_dt date;
4337: --
4338: