APPS.BEN_PDW_MASS_UPD_RATES dependencies on BEN_VRBL_RT_PRFL_F

Line 244: BEN_VRBL_RT_PRFL_F a

240: hr_utility.set_location('Uploading Variable Rate',15);
241: begin
242: select 'Y' into l_future_data_exists
243: from
244: BEN_VRBL_RT_PRFL_F a
245: where
246: vrbl_rt_prfl_id = p_rate_id
247: and p_effective_date between a.effective_start_date and a.effective_end_date
248: and a.effective_end_date < to_date('4712/12/31','YYYY/MM/DD')

Line 250: ( select 'Y' from BEN_VRBL_RT_PRFL_F b

246: vrbl_rt_prfl_id = p_rate_id
247: and p_effective_date between a.effective_start_date and a.effective_end_date
248: and a.effective_end_date < to_date('4712/12/31','YYYY/MM/DD')
249: and exists
250: ( select 'Y' from BEN_VRBL_RT_PRFL_F b
251: where b.vrbl_rt_prfl_id = a.vrbl_rt_prfl_id
252: and b.effective_start_date = a.effective_end_date + 1);
253: exception when no_data_found then
254: null;