470: l_outputs ff_exec.outputs_t;
471:
472: cursor c_abr is
473: select element_det_rl
474: from ben_acty_base_rt_f
475: where acty_base_rt_id = p_acty_base_rt_id
476: and p_effective_date between effective_start_date
477: and effective_end_date;
478:
4771: and cv_lf_evt_ocrd_dt between oipl.effective_start_date
4772: and oipl.effective_end_date
4773: and exists
4774: (select null
4775: from ben_acty_base_rt_f abr
4776: where abr.pl_id = cv_pl_id
4777: and cv_lf_evt_ocrd_dt between abr.effective_start_date
4778: and abr.effective_end_date
4779: and abr.acty_typ_cd = 'CWBWS' -- 9999