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

Line 353: from ben_pgm_f a

349: l_dummy varchar2(1);
350: --
351: cursor c1 is
352: select null
353: from ben_pgm_f a
354: where a.pgm_id = p_pgm_id
355: and p_effective_date
356: between a.effective_start_date
357: and a.effective_end_date;

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

368: and nvl(p_pgm_id,hr_api.g_number)
369: <> nvl(ben_cpy_shd.g_old_rec.pgm_id,hr_api.g_number)
370: or not l_api_updating) then
371: --
372: -- check if pgm_id value exists in ben_pgm_f table
373: --
374: open c1;
375: --
376: fetch c1 into l_dummy;

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

377: if c1%notfound then
378: --
379: close c1;
380: --
381: -- raise error as FK does not relate to PK in ben_pgm_f
382: -- table.
383: --
384: ben_cpy_shd.constraint_error('DATETRACK-ERROR');
385: --