5100: where p_effective_date
5101: between elp.effective_start_date
5102: and elp.effective_end_date
5103: and exists(select null
5104: from ben_elig_schedd_hrs_prte_f esh
5105: where p_effective_date
5106: between esh.effective_start_date
5107: and esh.effective_end_date
5108: and esh.eligy_prfl_id = elp.eligy_prfl_id)
5122: esh.freq_cd,
5123: esh.excld_flag,
5124: esh.criteria_score,
5125: esh.criteria_weight
5126: from ben_elig_schedd_hrs_prte_f esh
5127: where p_effective_date
5128: between esh.effective_start_date
5129: and esh.effective_end_date
5130: order by esh.eligy_prfl_id,