APPS.BEN_XWC_BUS dependencies on BEN_EXT_DATA_ELMT_IN_RCD

Line 220: from ben_ext_data_elmt_in_rcd a

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

Line 237: -- check if cond_ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table

233: <> nvl(ben_xwc_shd.g_old_rec.cond_ext_data_elmt_in_rcd_id,hr_api.g_number)
234: or not l_api_updating) and
235: p_cond_ext_data_elmt_in_rcd_id is not null then
236: --
237: -- check if cond_ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table
238: --
239: open c1;
240: --
241: fetch c1 into l_dummy;

Line 246: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd

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

Line 372: from ben_ext_data_elmt_in_rcd a

368: l_dummy varchar2(1);
369: --
370: cursor c1 is
371: select null
372: from ben_ext_data_elmt_in_rcd a
373: where a.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
374: --
375: Begin
376: --

Line 389: -- check if ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table

385: <> nvl(ben_xwc_shd.g_old_rec.ext_data_elmt_in_rcd_id,hr_api.g_number)
386: or not l_api_updating) and
387: p_ext_data_elmt_in_rcd_id is not null then
388: --
389: -- check if ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table
390: --
391: open c1;
392: --
393: fetch c1 into l_dummy;

Line 398: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd

394: if c1%notfound then
395: --
396: close c1;
397: --
398: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd
399: -- table.
400: --
401: ben_xwc_shd.constraint_error('BEN_EXT_WHERE_CLAUSE_FK3');
402: --