APPS.BEN_XIC_BUS dependencies on BEN_EXT_DATA_ELMT_IN_RCD

Line 353: from ben_ext_data_elmt_in_rcd a

349: l_dummy varchar2(1);
350: --
351: cursor c1 is
352: select null
353: from ben_ext_data_elmt_in_rcd a
354: where a.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
355: --
356: Begin
357: --

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

366: <> nvl(ben_xic_shd.g_old_rec.ext_data_elmt_in_rcd_id,hr_api.g_number)
367: or not l_api_updating) and
368: p_ext_data_elmt_in_rcd_id is not null then
369: --
370: -- check if ext_data_elmt_in_rcd_id value exists in ben_ext_data_elmt_in_rcd table
371: --
372: open c1;
373: --
374: fetch c1 into l_dummy;

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

375: if c1%notfound then
376: --
377: close c1;
378: --
379: -- raise error as FK does not relate to PK in ben_ext_data_elmt_in_rcd
380: -- table.
381: --
382: ben_xic_shd.constraint_error('BEN_EXT_INCL_CHG_FK1');
383: --

Line 436: from ben_ext_data_elmt_in_rcd

432: cursor c1 is select sprs_cd
433: from ben_ext_rcd_in_file
434: where ext_rcd_in_file_id = p_ext_rcd_in_file_id;
435: cursor c2 is select sprs_cd
436: from ben_ext_data_elmt_in_rcd
437: where ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;
438:
439: cursor c3 is
440: select 'x'