DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_PSTL_ZIP_RT_F

Line 2106: FROM ben_pstl_zip_rt_f epz

2102: --
2103: CURSOR get_elig_zip(p_vrbl_rt_prfl_id IN NUMBER
2104: ,cv_effective_date IN DATE) IS
2105: SELECT epz.pstl_zip_rng_id,epz.excld_flag
2106: FROM ben_pstl_zip_rt_f epz
2107: WHERE epz.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
2108: AND cv_effective_date -- FONM NVL(p_lf_evt_ocrd_dt, p_effective_date)
2109: BETWEEN epz.effective_start_date
2110: AND epz.effective_end_date;