2869: where p_effective_date
2870: between elp.effective_start_date
2871: and elp.effective_end_date
2872: and exists(select null
2873: from ben_eligy_prfl_rl_f erl
2874: where p_effective_date
2875: between erl.effective_start_date
2876: and erl.effective_end_date
2877: and erl.eligy_prfl_id = elp.eligy_prfl_id)
2883: 'ERL' short_code,
2884: erl.formula_id,
2885: erl.criteria_score,
2886: erl.criteria_weight
2887: from ben_eligy_prfl_rl_f erl
2888: where p_effective_date
2889: between erl.effective_start_date
2890: and erl.effective_end_date
2891: order by erl.eligy_prfl_id,