153: CURSOR c_abr_pl(
154: c_pl_id number,
155: c_effective_date DATE) IS
156: SELECT 'Y'
157: FROM ben_acty_base_rt_f abr
158: WHERE abr.acty_base_rt_stat_cd = 'A'
159: AND abr.pl_id = c_pl_id
160: AND abr.rt_usg_cd <> 'FLXCR'
161: and abr.acty_typ_cd in ('CWBWB','CWBDB')
165: CURSOR c_abr_oipl(
166: c_oipl_id number,
167: c_effective_date DATE) IS
168: SELECT 'Y'
169: FROM ben_acty_base_rt_f abr
170: WHERE abr.acty_base_rt_stat_cd = 'A'
171: AND abr.oipl_id = c_oipl_id
172: AND abr.rt_usg_cd <> 'FLXCR'
173: and abr.acty_typ_cd in ('CWBWB','CWBDB')