[Home] [Help]
7555: where p_effective_date
7556: between elp.effective_start_date
7557: and elp.effective_end_date
7558: and exists(select null
7559: from ben_elig_brgng_unit_prte_f ebu
7560: where p_effective_date
7561: between ebu.effective_start_date
7562: and ebu.effective_end_date
7563: and ebu.eligy_prfl_id = elp.eligy_prfl_id)
7570: ebu.brgng_unit_cd,
7571: ebu.excld_flag,
7572: ebu.criteria_score,
7573: ebu.criteria_weight
7574: from ben_elig_brgng_unit_prte_f ebu
7575: where p_effective_date
7576: between ebu.effective_start_date
7577: and ebu.effective_end_date
7578: order by ebu.eligy_prfl_id,