APPS.BEN_XFI_BUS dependencies on BEN_EXT_FILE

Line 24: , ben_ext_file xfi

20: --
21: cursor csr_sec_grp is
22: select pbg.security_group_id
23: from per_business_groups pbg
24: , ben_ext_file xfi
25: where xfi.ext_file_id = p_ext_file_id
26: and pbg.business_group_id = xfi.business_group_id;
27: --
28: -- Declare local variables

Line 117: ben_xfi_shd.constraint_error('BEN_EXT_FILE_PK');

113: <> ben_xfi_shd.g_old_rec.ext_file_id) then
114: --
115: -- raise error as PK has changed
116: --
117: ben_xfi_shd.constraint_error('BEN_EXT_FILE_PK');
118: --
119: elsif not l_api_updating then
120: --
121: -- check if PK is null

Line 127: ben_xfi_shd.constraint_error('BEN_EXT_FILE_PK');

123: if p_ext_file_id is not null then
124: --
125: -- raise error as PK is not null
126: --
127: ben_xfi_shd.constraint_error('BEN_EXT_FILE_PK');
128: --
129: end if;
130: --
131: end if;

Line 171: from ben_ext_file

167: is
168: l_proc varchar2(72) := g_package||'chk_name_unique';
169: l_dummy char(1);
170: cursor c1 is select null
171: from ben_ext_file
172: Where ext_file_id <> nvl(p_ext_file_id,-1)
173: and name = p_name
174: and ( (business_group_id is null -- is global
175: and legislation_code is null

Line 349: ben_ext_file b

345: --
346: cursor csr_leg_code is
347: select a.legislation_code
348: from per_business_groups a,
349: ben_ext_file b
350: where b.ext_file_id = p_ext_file_id
351: and a.business_group_id(+) = b.business_group_id;
352: --
353: -- Declare local variables