7123: where p_effective_date
7124: between elp.effective_start_date
7125: and elp.effective_end_date
7126: and exists(select null
7127: from ben_elig_pyrl_prte_f epy
7128: where p_effective_date
7129: between epy.effective_start_date
7130: and epy.effective_end_date
7131: and epy.eligy_prfl_id = elp.eligy_prfl_id)
7138: epy.payroll_id,
7139: epy.excld_flag,
7140: epy.criteria_score,
7141: epy.criteria_weight
7142: from ben_elig_pyrl_prte_f epy
7143: where p_effective_date
7144: between epy.effective_start_date
7145: and epy.effective_end_date
7146: order by epy.eligy_prfl_id,