APPS.BEN_PDW_MASS_UPD_RATES dependencies on BEN_ACTY_BASE_RT_F

Line 164: BEN_ACTY_BASE_RT_F a

160: hr_utility.set_location('UPloading Standard Rate',15);
161: begin
162: select 'Y' into l_future_data_exists
163: from
164: BEN_ACTY_BASE_RT_F a
165: where
166: a.acty_base_rt_id = p_rate_id
167: and p_effective_date between a.effective_start_date and a.effective_end_date
168: and a.effective_end_date < to_date('4712/12/31','YYYY/MM/DD')

Line 170: ( select 'Y' from BEN_ACTY_BASE_RT_F b

166: a.acty_base_rt_id = p_rate_id
167: and p_effective_date between a.effective_start_date and a.effective_end_date
168: and a.effective_end_date < to_date('4712/12/31','YYYY/MM/DD')
169: and exists
170: ( select 'Y' from BEN_ACTY_BASE_RT_F b
171: where b.acty_base_rt_id = a.acty_base_rt_id
172: and b.effective_start_date = a.effective_end_date + 1);
173: exception when no_data_found then
174: null;