6289: where p_effective_date
6290: between elp.effective_start_date
6291: and elp.effective_end_date
6292: and exists(select null
6293: from ben_elig_grd_prte_f egr
6294: where p_effective_date
6295: between egr.effective_start_date
6296: and egr.effective_end_date
6297: and egr.eligy_prfl_id = elp.eligy_prfl_id)
6304: egr.grade_id,
6305: egr.excld_flag,
6306: egr.criteria_score,
6307: egr.criteria_weight
6308: from ben_elig_grd_prte_f egr
6309: where p_effective_date
6310: between egr.effective_start_date
6311: and egr.effective_end_date
6312: order by egr.eligy_prfl_id,
6543: where p_effective_date
6544: between elp.effective_start_date
6545: and elp.effective_end_date
6546: and exists(select null
6547: from ben_elig_grd_prte_f egn
6548: where p_effective_date
6549: between egn.effective_start_date
6550: and egn.effective_end_date
6551: and egn.eligy_prfl_id = elp.eligy_prfl_id)