APPS.BEN_XCC_BUS dependencies on BEN_EXT_CRIT_CMBN

Line 72: , ben_ext_crit_cmbn xcc

68: --
69: cursor csr_sec_grp is
70: select pbg.security_group_id
71: from per_business_groups pbg
72: , ben_ext_crit_cmbn xcc
73: where xcc.ext_crit_cmbn_id = p_ext_crit_cmbn_id
74: and pbg.business_group_id = xcc.business_group_id;
75: --
76: -- Declare local variables

Line 165: ben_xcc_shd.constraint_error('BEN_EXT_CRIT_CMBN_PK');

161: <> ben_xcc_shd.g_old_rec.ext_crit_cmbn_id) then
162: --
163: -- raise error as PK has changed
164: --
165: ben_xcc_shd.constraint_error('BEN_EXT_CRIT_CMBN_PK');
166: --
167: elsif not l_api_updating then
168: --
169: -- check if PK is null

Line 175: ben_xcc_shd.constraint_error('BEN_EXT_CRIT_CMBN_PK');

171: if p_ext_crit_cmbn_id is not null then
172: --
173: -- raise error as PK is not null
174: --
175: ben_xcc_shd.constraint_error('BEN_EXT_CRIT_CMBN_PK');
176: --
177: end if;
178: --
179: end if;

Line 248: ben_xcc_shd.constraint_error('BEN_EXT_CRIT_CMBN_FK1');

244: --
245: -- raise error as FK does not relate to PK in ben_ext_crit_val
246: -- table.
247: --
248: ben_xcc_shd.constraint_error('BEN_EXT_CRIT_CMBN_FK1');
249: --
250: end if;
251: --
252: close c1;

Line 967: ben_ext_crit_cmbn b

963: --
964: cursor csr_leg_code is
965: select a.legislation_code
966: from per_business_groups a,
967: ben_ext_crit_cmbn b
968: where b.ext_crit_cmbn_id = p_ext_crit_cmbn_id
969: and a.business_group_id(+) = b.business_group_id;
970: --
971: -- Declare local variables