APPS.BEN_XIC_BUS dependencies on BEN_EXT_INCL_CHG

Line 129: , ben_ext_incl_chg xic

125: --
126: cursor csr_sec_grp is
127: select pbg.security_group_id
128: from per_business_groups_perf pbg
129: , ben_ext_incl_chg xic
130: where xic.ext_incl_chg_id = p_ext_incl_chg_id
131: and pbg.business_group_id = xic.business_group_id;
132: --
133: -- Declare local variables

Line 222: ben_xic_shd.constraint_error('BEN_EXT_INCL_CHG_PK');

218: <> ben_xic_shd.g_old_rec.ext_incl_chg_id) then
219: --
220: -- raise error as PK has changed
221: --
222: ben_xic_shd.constraint_error('BEN_EXT_INCL_CHG_PK');
223: --
224: elsif not l_api_updating then
225: --
226: -- check if PK is null

Line 232: ben_xic_shd.constraint_error('BEN_EXT_INCL_CHG_PK');

228: if p_ext_incl_chg_id is not null then
229: --
230: -- raise error as PK is not null
231: --
232: ben_xic_shd.constraint_error('BEN_EXT_INCL_CHG_PK');
233: --
234: end if;
235: --
236: end if;

Line 306: ben_xic_shd.constraint_error('BEN_EXT_INCL_CHG_FK2');

302: --
303: -- raise error as FK does not relate to PK in ben_ext_rcd_in_file
304: -- table.
305: --
306: ben_xic_shd.constraint_error('BEN_EXT_INCL_CHG_FK2');
307: --
308: end if;
309: --
310: close c1;

Line 382: ben_xic_shd.constraint_error('BEN_EXT_INCL_CHG_FK1');

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: --
384: end if;
385: --
386: close c1;

Line 567: from ben_ext_incl_chg

563: l_proc varchar2(72) := g_package||'chk_unique_chg_evt_cd';
564: l_api_updating boolean;
565: --
566: cursor c1 is select 'x'
567: from ben_ext_incl_chg
568: where ext_rcd_in_file_id = p_ext_rcd_in_file_id
569: and chg_evt_cd = p_chg_evt_cd
570: and (p_ext_incl_chg_id <> ext_incl_chg_id or p_ext_incl_chg_id is null ) ;
571:

Line 574: from ben_ext_incl_chg

570: and (p_ext_incl_chg_id <> ext_incl_chg_id or p_ext_incl_chg_id is null ) ;
571:
572:
573: cursor c2 is select 'x'
574: from ben_ext_incl_chg
575: where ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
576: and chg_evt_cd = p_chg_evt_cd
577: and (p_ext_incl_chg_id <> ext_incl_chg_id or p_ext_incl_chg_id is null ) ;
578: l_dummy varchar2(1) ;

Line 809: from ben_ext_incl_chg b

805: -- Declare cursor
806: --
807: cursor csr_leg_code is
808: select b.business_group_id
809: from ben_ext_incl_chg b
810: where b.ext_incl_chg_id = p_ext_incl_chg_id
811: ;
812: --
813: -- Declare local variables