APPS.BEN_PEL_BUS dependencies on BEN_LEE_RSN_F

Line 265: from ben_lee_rsn_f a

261: l_dummy varchar2(1);
262: --
263: cursor c1 is
264: select null
265: from ben_lee_rsn_f a
266: where a.lee_rsn_id = p_lee_rsn_id
267: and p_effective_date
268: between a.effective_start_date
269: and a.effective_end_date;

Line 284: -- check if lee_rsn_id value exists in ben_lee_rsn_f table

280: and nvl(p_lee_rsn_id,hr_api.g_number)
281: <> nvl(ben_pel_shd.g_old_rec.lee_rsn_id,hr_api.g_number)
282: or not l_api_updating) then
283: --
284: -- check if lee_rsn_id value exists in ben_lee_rsn_f table
285: --
286: open c1;
287: --
288: fetch c1 into l_dummy;

Line 293: -- raise error as FK does not relate to PK in ben_lee_rsn_f

289: if c1%notfound then
290: --
291: close c1;
292: --
293: -- raise error as FK does not relate to PK in ben_lee_rsn_f
294: -- table.
295: --
296: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_DT1');
297: --