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