DBA Data[Home] [Help]

APPS.BEN_XCC_BUS dependencies on BEN_EXT_CRIT_VAL

Line 220: from ben_ext_crit_val a

216: l_dummy varchar2(1);
217: --
218: cursor c1 is
219: select null
220: from ben_ext_crit_val a
221: where a.ext_crit_val_id = p_ext_crit_val_id;
222: --
223: Begin
224: --

Line 236: -- check if ext_crit_val_id value exists in ben_ext_crit_val table

232: and nvl(p_ext_crit_val_id,hr_api.g_number)
233: <> nvl(ben_xcc_shd.g_old_rec.ext_crit_val_id,hr_api.g_number)
234: or not l_api_updating) then
235: --
236: -- check if ext_crit_val_id value exists in ben_ext_crit_val table
237: --
238: open c1;
239: --
240: fetch c1 into l_dummy;

Line 245: -- raise error as FK does not relate to PK in ben_ext_crit_val

241: if c1%notfound then
242: --
243: close c1;
244: --
245: -- raise error as FK does not relate to PK in ben_ext_crit_val
246: -- table.
247: --
248: ben_xcc_shd.constraint_error('BEN_EXT_CRIT_CMBN_FK1');
249: --