[Home] [Help]
962: cursor c1 is
963: select ecr.ann_mn_elcn_val, ecr.ann_mx_elcn_val, ecr.acty_base_rt_id,
964: ecr.elig_per_elctbl_chc_id, ecr.enrt_bnft_id, ecr.object_version_number,
965: ecr.entr_ann_val_flag, dsply_mn_elcn_val, dsply_mx_elcn_val,incrmt_elcn_val
966: From ben_enrt_rt ecr
967: where ecr.enrt_rt_id=p_enrt_rt_id;
968: l_c1 c1%rowtype;
969:
970: cursor c2 (p_enrt_bnft_id number) is
984: null,
985: enb.elig_per_elctbl_chc_id,
986: ecr.elig_per_elctbl_chc_id
987: )
988: from ben_enrt_rt ecr,
989: ben_enrt_bnft enb
990: where ecr.enrt_rt_id = p_enrt_rt_id and
991: enb.enrt_bnft_id(+) = ecr.enrt_bnft_id;
992:
1101: ,p_clm_balance => l_clm_balance ) ;
1102:
1103: -- Bug: 4272271. Since prorate_min_max is not called, no need to call update_enrollment_rate
1104:
1105: -- If the values changed, update ben_enrt_rt so that the display will be
1106: -- correct.
1107: /*
1108: if l_ann_mn_elcn_val <> l_c1.ann_mn_elcn_val or
1109: l_ann_mx_elcn_val <> l_c1.ann_mx_elcn_val then
1226: acty_base_rt_id,
1227: rt_mlt_cd ,
1228: entr_val_at_enrt_flag,
1229: entr_ann_val_flag
1230: from ben_enrt_rt
1231: where enrt_rt_id=p_enrt_rt_id ;
1232:
1233:
1234: cursor c_abr (p_acty_base_rt_id number , p_effective_date date) is
1242: null,
1243: enb.elig_per_elctbl_chc_id,
1244: ecr.elig_per_elctbl_chc_id
1245: )
1246: from ben_enrt_rt ecr,
1247: ben_enrt_bnft enb
1248: where ecr.enrt_rt_id = p_enrt_rt_id and
1249: enb.enrt_bnft_id (+) = ecr.enrt_bnft_id;
1250: