6879: where p_effective_date
6880: between elp.effective_start_date
6881: and elp.effective_end_date
6882: and exists(select null
6883: from ben_elig_py_bss_prte_f epb
6884: where p_effective_date
6885: between epb.effective_start_date
6886: and epb.effective_end_date
6887: and epb.eligy_prfl_id = elp.eligy_prfl_id)
6894: epb.pay_basis_id,
6895: epb.excld_flag,
6896: epb.criteria_score,
6897: epb.criteria_weight
6898: from ben_elig_py_bss_prte_f epb
6899: where p_effective_date
6900: between epb.effective_start_date
6901: and epb.effective_end_date
6902: order by epb.eligy_prfl_id,