DBA Data[Home] [Help]

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;