8363: where p_effective_date
8364: between elp.effective_start_date
8365: and elp.effective_end_date
8366: and exists(select null
8367: from ben_elig_pstl_cd_r_rng_prte_f epz,
8368: ben_pstl_zip_rng_f rzr
8369: where epz.pstl_zip_rng_id = rzr.pstl_zip_rng_id
8370: and epz.business_group_id = rzr.business_group_id
8371: and p_effective_date
8385: epz.criteria_score,
8386: epz.criteria_weight,
8387: rzr.from_value,
8388: rzr.to_value
8389: from ben_elig_pstl_cd_r_rng_prte_f epz,
8390: ben_pstl_zip_rng_f rzr
8391: where epz.pstl_zip_rng_id = rzr.pstl_zip_rng_id
8392: and epz.business_group_id = rzr.business_group_id
8393: and p_effective_date