2597: where p_effective_date
2598: between elp.effective_start_date
2599: and elp.effective_end_date
2600: and exists(select null
2601: from ben_elig_asnt_set_prte_f ean
2602: where p_effective_date
2603: between ean.effective_start_date
2604: and ean.effective_end_date
2605: and ean.eligy_prfl_id = elp.eligy_prfl_id)
2612: ass.formula_id,
2613: ean.excld_flag,
2614: ean.criteria_score,
2615: ean.criteria_weight
2616: from ben_elig_asnt_set_prte_f ean,
2617: hr_assignment_sets ass
2618: where p_effective_date
2619: between ean.effective_start_date
2620: and ean.effective_end_date