DBA Data[Home] [Help]

APPS.BEN_PEL_BUS dependencies on BEN_ENRT_PERD

Line 343: from ben_enrt_perd a

339: l_dummy varchar2(1);
340: --
341: cursor c1 is
342: select null
343: from ben_enrt_perd a
344: where a.enrt_perd_id = p_enrt_perd_id;
345: --
346: Begin
347: --

Line 360: -- check if enrt_perd_id value exists in ben_enrt_perd table

356: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_id,hr_api.g_number)) --Bug 4068639
357: or not l_api_updating) and
358: p_enrt_perd_id is not null then
359: --
360: -- check if enrt_perd_id value exists in ben_enrt_perd table
361: --
362: open c1;
363: --
364: fetch c1 into l_dummy;

Line 369: -- raise error as FK does not relate to PK in ben_enrt_perd

365: if c1%notfound then
366: --
367: close c1;
368: --
369: -- raise error as FK does not relate to PK in ben_enrt_perd
370: -- table.
371: --
372: ben_pel_shd.constraint_error('BEN_PIL_ELCTBL_CHC_POPL_FK1');
373: --