eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_XIC_BUS dependencies on BEN_EXT_RCD_IN_FILE

Line 277: from ben_ext_rcd_in_file a

273: l_dummy varchar2(1);
274: --
275: cursor c1 is
276: select null
277: from ben_ext_rcd_in_file a
278: where a.ext_rcd_in_file_id = p_ext_rcd_in_file_id;
279: --
280: Begin
281: --

Line 294: -- check if ext_rcd_in_file_id value exists in ben_ext_rcd_in_file table

290: <> nvl(ben_xic_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)
291: or not l_api_updating) and
292: p_ext_rcd_in_file_id is not null then
293: --
294: -- check if ext_rcd_in_file_id value exists in ben_ext_rcd_in_file table
295: --
296: open c1;
297: --
298: fetch c1 into l_dummy;

Line 303: -- raise error as FK does not relate to PK in ben_ext_rcd_in_file

299: if c1%notfound then
300: --
301: close c1;
302: --
303: -- raise error as FK does not relate to PK in ben_ext_rcd_in_file
304: -- table.
305: --
306: ben_xic_shd.constraint_error('BEN_EXT_INCL_CHG_FK2');
307: --

Line 433: from ben_ext_rcd_in_file

429: l_proc varchar2(72) := g_package||'chk_chg_evt_cd';
430: l_api_updating boolean;
431: --
432: cursor c1 is select sprs_cd
433: from ben_ext_rcd_in_file
434: where ext_rcd_in_file_id = p_ext_rcd_in_file_id;
435: cursor c2 is select sprs_cd
436: from ben_ext_data_elmt_in_rcd
437: where ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id;