APPS.BEN_XRD_BUS dependencies on BEN_EXT_RCD

Line 191: from ben_ext_rcd a

187: l_dummy varchar2(1);
188: --
189: cursor c1 is
190: select null
191: from ben_ext_rcd a
192: where a.ext_rcd_id = p_ext_rcd_id;
193: --
194: Begin
195: --

Line 207: -- check if ext_rcd_id value exists in ben_ext_rcd table

203: and nvl(p_ext_rcd_id,hr_api.g_number)
204: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_id,hr_api.g_number)
205: or not l_api_updating) then
206: --
207: -- check if ext_rcd_id value exists in ben_ext_rcd table
208: --
209: open c1;
210: --
211: fetch c1 into l_dummy;

Line 216: -- raise error as FK does not relate to PK in ben_ext_rcd

212: if c1%notfound then
213: --
214: close c1;
215: --
216: -- raise error as FK does not relate to PK in ben_ext_rcd
217: -- table.
218: --
219: ben_xrd_shd.constraint_error('BEN_EXT_RSLT_DTL_FK3');
220: --

Line 245: from ben_ext_rcd_in_file a

241: l_dummy varchar2(1);
242: --
243: cursor c1 is
244: select null
245: from ben_ext_rcd_in_file a
246: where a.ext_rcd_in_file_id = p_ext_rcd_in_file_id;
247: --
248: Begin
249: --

Line 261: -- check if ext_rcd_id value exists in ben_ext_rcd table

257: and nvl(p_ext_rcd_in_file_id,hr_api.g_number)
258: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)
259: or not l_api_updating) and p_ext_rcd_in_file_id is not null then
260: --
261: -- check if ext_rcd_id value exists in ben_ext_rcd table
262: --
263: open c1;
264: --
265: fetch c1 into l_dummy;

Line 270: -- raise error as FK does not relate to PK in ben_ext_rcd

266: if c1%notfound then
267: --
268: close c1;
269: --
270: -- raise error as FK does not relate to PK in ben_ext_rcd
271: -- table.
272: --
273: ben_xrd_shd.constraint_error('BEN_EXT_RSLT_DTL_FK3');
274: --