DBA Data[Home] [Help]

APPS.BEN_BLI_BUS dependencies on BEN_BENEFIT_ACTIONS

Line 271: from ben_benefit_actions a

267: l_dummy varchar2(1);
268: --
269: cursor c1 is
270: select null
271: from ben_benefit_actions a
272: where a.benefit_action_id = p_benefit_action_id;
273: --
274: Begin
275: --

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

283: and nvl(p_benefit_action_id,hr_api.g_number)
284: <> nvl(ben_bli_shd.g_old_rec.benefit_action_id,hr_api.g_number)
285: or not l_api_updating) then
286: --
287: -- check if benefit_action_id value exists in ben_benefit_actions table
288: --
289: open c1;
290: --
291: fetch c1 into l_dummy;

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

292: if c1%notfound then
293: --
294: close c1;
295: --
296: -- raise error as FK does not relate to PK in ben_benefit_actions
297: -- table.
298: --
299: ben_bli_shd.constraint_error('BEN_BATCH_LER_INFO_FK1');
300: --