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_ABR_UPD dependencies on BEN_OIPL_F

Line 441: from ben_oipl_f

437: l_proc varchar2(72) := g_package||'pre_update';
438: --
439: cursor c_oipl is
440: select opt_id, pl_id
441: from ben_oipl_f
442: where oipl_id = p_rec.oipl_id
443: and p_effective_date between effective_start_date and effective_end_date;
444: --
445: l_oipl c_oipl%rowtype;

Line 457: from ben_oiplip_f oiplip, ben_oipl_f oipl, ben_plip_f plip

453: l_plip c_plip%rowtype;
454: --
455: cursor c_oiplip is
456: select plip.pgm_id, oipl.pl_id, oipl.opt_id
457: from ben_oiplip_f oiplip, ben_oipl_f oipl, ben_plip_f plip
458: where oiplip.oiplip_id = p_rec.oiplip_id
459: and oiplip.oipl_id = oipl.oipl_id
460: and oiplip.plip_id = plip.plip_id
461: and oipl.pl_id = plip.pl_id