APPS.BEN_EVALUATE_RATE_PROFILES dependencies on BEN_SVC_AREA_RT_F
Line 2749: FROM ben_svc_area_rt_f sar
2745: --
2746: CURSOR get_elig_svc (p_vrbl_rt_prfl_id IN NUMBER
2747: ,cv_effective_date IN DATE) IS
2748: SELECT sar.svc_area_id, sar.excld_flag 2749: FROM ben_svc_area_rt_f sar 2750: WHERE sar.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
2751: AND cv_effective_date -- FONM NVL(p_lf_evt_ocrd_dt, p_effective_date)
2752: BETWEEN sar.effective_start_date
2753: AND sar.effective_end_date;