DBA Data[Home] [Help]

APPS.BEN_XWC_BUS dependencies on BEN_EXT_RCD_IN_FILE

Line 296: from ben_ext_rcd_in_file a

292: l_dummy varchar2(1);
293: --
294: cursor c1 is
295: select null
296: from ben_ext_rcd_in_file a
297: where a.ext_rcd_in_file_id = p_ext_rcd_in_file_id;
298: --
299: Begin
300: --

Line 313: -- check if ext_rcd_in_file_id value exists in ben_ext_rcd_in_file table

309: <> nvl(ben_xwc_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)
310: or not l_api_updating) and
311: p_ext_rcd_in_file_id is not null then
312: --
313: -- check if ext_rcd_in_file_id value exists in ben_ext_rcd_in_file table
314: --
315: open c1;
316: --
317: fetch c1 into l_dummy;

Line 322: -- raise error as FK does not relate to PK in ben_ext_rcd_in_file

318: if c1%notfound then
319: --
320: close c1;
321: --
322: -- raise error as FK does not relate to PK in ben_ext_rcd_in_file
323: -- table.
324: --
325: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK4');
326: --