DBA Data[Home] [Help]

APPS.BEN_BEI_BUS dependencies on BEN_BENEFIT_ACTIONS

Line 434: from ben_benefit_actions a

430: l_dummy varchar2(1);
431: --
432: cursor c1 is
433: select null
434: from ben_benefit_actions a
435: where a.benefit_action_id = p_benefit_action_id;
436: --
437: Begin
438: --

Line 450: -- check if benefit_action_id value exists in ben_benefit_actions table

446: and nvl(p_benefit_action_id,hr_api.g_number)
447: <> nvl(ben_bei_shd.g_old_rec.benefit_action_id,hr_api.g_number)
448: or not l_api_updating) then
449: --
450: -- check if benefit_action_id value exists in ben_benefit_actions table
451: --
452: open c1;
453: --
454: fetch c1 into l_dummy;

Line 459: -- raise error as FK does not relate to PK in ben_benefit_actions

455: if c1%notfound then
456: --
457: close c1;
458: --
459: -- raise error as FK does not relate to PK in ben_benefit_actions
460: -- table.
461: --
462: ben_bei_shd.constraint_error('BEN_BATCH_ELIG_INFO_FK1');
463: --