DBA Data[Home] [Help]

APPS.BEN_XCT_BUS dependencies on BEN_EXT_CRIT_PRFL

Line 220: from ben_ext_crit_prfl a

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

Line 236: -- check if ext_crit_prfl_id value exists in ben_ext_crit_prfl table

232: and nvl(p_ext_crit_prfl_id,hr_api.g_number)
233: <> nvl(ben_xct_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)
234: or not l_api_updating) then
235: --
236: -- check if ext_crit_prfl_id value exists in ben_ext_crit_prfl 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_prfl

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