344: ))
345: OR EXISTS /* Enrollment Certification Required - Plan */
346: (
347: SELECT 1
348: FROM ben_enrt_ctfn_f ecf
349: WHERE ecf.pl_id = pln.pl_id
350: AND cv_end_date BETWEEN ecf.effective_start_date
351: AND ecf.effective_end_date)
352: OR EXISTS /* Enrollment Certification Required - Plan Life Event */
363: AND lre.pl_id = pln.pl_id)
364: OR EXISTS /* Enrollment Certification Required - Option in Plan*/
365: (
366: SELECT 1
367: FROM ben_oipl_f cop, ben_enrt_ctfn_f ecf
368: WHERE ecf.oipl_id = cop.oipl_id
369: AND cv_end_date BETWEEN ecf.effective_start_date
370: AND ecf.effective_end_date
371: AND cv_end_date BETWEEN cop.effective_start_date