243: l_dummy varchar2(1);
244: --
245: cursor c1 is
246: select null
247: from ben_ext_crit_prfl a
248: where a.ext_crit_prfl_id = p_ext_crit_prfl_id;
249: --
250: Begin
251: --
260: <> nvl(ben_xdf_shd.g_old_rec.ext_crit_prfl_id,hr_api.g_number)
261: or not l_api_updating) and
262: p_ext_crit_prfl_id is not null then
263: --
264: -- check if ext_crit_prfl_id value exists in ben_ext_crit_prfl table
265: --
266: open c1;
267: --
268: fetch c1 into l_dummy;
269: if c1%notfound then
270: --
271: close c1;
272: --
273: -- raise error as FK does not relate to PK in ben_ext_crit_prfl
274: -- table.
275: --
276: ben_xdf_shd.constraint_error('BEN_EXT_DFN_FK1');
277: --