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_BEI_BUS dependencies on BEN_PGM_F

Line 275: from ben_pgm_f a

271: l_dummy varchar2(1);
272: --
273: cursor c1 is
274: select null
275: from ben_pgm_f a
276: where a.pgm_id = p_pgm_id
277: and p_effective_date
278: between a.effective_start_date
279: and a.effective_end_date;

Line 295: -- check if pgm_id value exists in ben_pgm_f table

291: <> nvl(ben_bei_shd.g_old_rec.pgm_id,hr_api.g_number)
292: or not l_api_updating)
293: and p_pgm_id is not null then
294: --
295: -- check if pgm_id value exists in ben_pgm_f table
296: --
297: open c1;
298: --
299: fetch c1 into l_dummy;

Line 304: -- raise error as FK does not relate to PK in ben_pgm_f

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