9596: where p_effective_date
9597: between elp.effective_start_date
9598: and elp.effective_end_date
9599: and exists(select null
9600: from ben_elig_dpnt_othr_ptip_f etd
9601: where p_effective_date
9602: between etd.effective_start_date
9603: and etd.effective_end_date
9604: and etd.eligy_prfl_id = elp.eligy_prfl_id)
9608: select etd.eligy_prfl_id,
9609: etd.ptip_id,
9610: --etd.only_pls_subj_cobra_flag,
9611: etd.excld_flag
9612: from ben_elig_dpnt_othr_ptip_f etd
9613: where p_effective_date
9614: between etd.effective_start_date
9615: and etd.effective_end_date
9616: order by etd.eligy_prfl_id,