DBA Data[Home] [Help]

APPS.BEN_XDF_BUS dependencies on BEN_EXT_FILE

Line 171: from ben_ext_file a

167: l_dummy varchar2(1);
168: --
169: cursor c1 is
170: select null
171: from ben_ext_file a
172: where a.ext_file_id = p_ext_file_id;
173: --
174: Begin
175: --

Line 188: -- check if ext_file_id value exists in ben_ext_file table

184: <> nvl(ben_xdf_shd.g_old_rec.ext_file_id,hr_api.g_number)
185: or not l_api_updating) and
186: p_ext_file_id is not null then
187: --
188: -- check if ext_file_id value exists in ben_ext_file table
189: --
190: open c1;
191: --
192: fetch c1 into l_dummy;

Line 197: -- raise error as FK does not relate to PK in ben_ext_file

193: if c1%notfound then
194: --
195: close c1;
196: --
197: -- raise error as FK does not relate to PK in ben_ext_file
198: -- table.
199: --
200: ben_xdf_shd.constraint_error('BEN_EXT_DFN_FK2');
201: --