APPS.BEN_PRV_BUS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 193: from pay_element_entry_values_f a

189: l_dummy varchar2(1);
190: --
191: cursor c1 is
192: select null
193: from pay_element_entry_values_f a
194: where a.element_entry_value_id = p_element_entry_value_id
195: and p_effective_date
196: between a.effective_start_date
197: and a.effective_end_date;

Line 212: -- check if element_entry_value_id value exists in pay_element_entry_values_f table

208: and nvl(p_element_entry_value_id,hr_api.g_number)
209: <> nvl(ben_prv_shd.g_old_rec.element_entry_value_id,hr_api.g_number)
210: or not l_api_updating) then
211: --
212: -- check if element_entry_value_id value exists in pay_element_entry_values_f table
213: --
214: open c1;
215: --
216: fetch c1 into l_dummy;

Line 221: -- raise error as FK does not relate to PK in pay_element_entry_values_f

217: if c1%notfound then
218: --
219: close c1;
220: --
221: -- raise error as FK does not relate to PK in pay_element_entry_values_f
222: -- table.
223: --
224: ben_prv_shd.constraint_error('BEN_PRTT_RT_VAL_DT2');
225: --