APPS.BEN_BDI_BUS dependencies on BEN_OIPL_F

Line 193: from ben_oipl_f a

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

Line 213: -- check if oipl_id value exists in ben_oipl_f table

209: <> nvl(ben_bdi_shd.g_old_rec.oipl_id,hr_api.g_number)
210: or not l_api_updating) and
211: p_oipl_id is not null) then
212: --
213: -- check if oipl_id value exists in ben_oipl_f table
214: --
215: open c1;
216: --
217: fetch c1 into l_dummy;

Line 222: -- raise error as FK does not relate to PK in ben_oipl_f

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