APPS.BEN_XCR_BUS dependencies on BEN_EXT_CRIT_PRFL

Line 24: , ben_ext_crit_prfl xcr

20: --
21: cursor csr_sec_grp is
22: select pbg.security_group_id
23: from per_business_groups pbg
24: , ben_ext_crit_prfl xcr
25: where xcr.ext_crit_prfl_id = p_ext_crit_prfl_id
26: and pbg.business_group_id = xcr.business_group_id;
27: --
28: -- Declare local variables

Line 165: ben_xcr_shd.constraint_error('BEN_EXT_CRIT_PRFL_PK');

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

Line 175: ben_xcr_shd.constraint_error('BEN_EXT_CRIT_PRFL_PK');

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

Line 224: from ben_ext_crit_prfl a

220: l_dummy char(1);
221: l_api_updating boolean;
222: --
223: cursor c1 is select null
224: from ben_ext_crit_prfl a
225: Where a.ext_crit_prfl_id <> nvl(p_ext_crit_prfl_id,hr_api.g_number)
226: and a.name = p_name
227: and ((business_group_id is null and legislation_code is null)
228: or (legislation_code is not null

Line 474: ben_ext_crit_prfl b

470: --
471: cursor csr_leg_code is
472: select a.legislation_code
473: from per_business_groups a,
474: ben_ext_crit_prfl b
475: where b.ext_crit_prfl_id = p_ext_crit_prfl_id
476: and a.business_group_id(+) = b.business_group_id;
477: --
478: -- Declare local variables