[Home] [Help]
12592: where p_effective_date
12593: between elp.effective_start_date
12594: and elp.effective_end_date
12595: and exists(select null
12596: from ben_elig_dpnt_cvrd_othr_ptip_f edt
12597: where p_effective_date
12598: between edt.effective_start_date
12599: and edt.effective_end_date
12600: and edt.eligy_prfl_id = elp.eligy_prfl_id)
12605: edt.excld_flag,
12606: edt.enrl_det_dt_cd,
12607: edt.only_pls_subj_cobra_flag,
12608: edt.ptip_id
12609: from ben_elig_dpnt_cvrd_othr_ptip_f edt
12610: where p_effective_date
12611: between edt.effective_start_date
12612: and edt.effective_end_date
12613: order by edt.eligy_prfl_id,