97: between pln.effective_start_date and pln.effective_end_date
98: */
99: and (c_include_erl = 'Y' or
100: not exists (select null 101: from ben_enrt_bnft enb 102: where pen.prtt_enrt_rslt_id = enb.prtt_enrt_rslt_id
103: and enb.cvg_mlt_cd = 'ERL'))
104: order by 1,2,3,4,5,6,7;
105: --