9614: where p_effective_date
9615: between elp.effective_start_date
9616: and elp.effective_end_date
9617: and exists(select null
9618: from ben_elig_othr_ptip_prte_f eoy
9619: where p_effective_date
9620: between eoy.effective_start_date
9621: and eoy.effective_end_date
9622: and eoy.eligy_prfl_id = elp.eligy_prfl_id)
9626: select eoy.eligy_prfl_id,
9627: eoy.ptip_id,
9628: eoy.only_pls_subj_cobra_flag,
9629: eoy.excld_flag
9630: from ben_elig_othr_ptip_prte_f eoy
9631: where p_effective_date
9632: between eoy.effective_start_date
9633: and eoy.effective_end_date
9634: order by eoy.eligy_prfl_id,