9355: where p_effective_date
9356: between elp.effective_start_date
9357: and elp.effective_end_date
9358: and exists(select null
9359: from ben_elig_othr_ptip_prte_f eoy
9360: where p_effective_date
9361: between eoy.effective_start_date
9362: and eoy.effective_end_date
9363: and eoy.eligy_prfl_id = elp.eligy_prfl_id)
9367: select eoy.eligy_prfl_id,
9368: eoy.ptip_id,
9369: eoy.only_pls_subj_cobra_flag,
9370: eoy.excld_flag
9371: from ben_elig_othr_ptip_prte_f eoy
9372: where p_effective_date
9373: between eoy.effective_start_date
9374: and eoy.effective_end_date
9375: order by eoy.eligy_prfl_id,