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

Line 249: ,ben_oipl_f oipl

245: --
246: select pen.*
247: from ben_elig_per_opt_f epo
248: ,ben_prtt_enrt_rslt_f pen
249: ,ben_oipl_f oipl
250: ,ben_elig_per_f pep
251: where pen.pgm_id = p_pgm_id
252: ---Bug 7301670
253: and pen.pgm_id = pep.pgm_id

Line 279: ,ben_oipl_f oipl

275: --
276: select pen.*
277: from ben_elig_per_opt_f epo
278: ,ben_prtt_enrt_rslt_f pen
279: ,ben_oipl_f oipl
280: ,ben_elig_per_f pep
281: where pen.pl_id = p_pl_id
282: and pep.pl_id = pen.pl_id
283: and pen.oipl_id = oipl.oipl_id

Line 494: l_oipl_rec ben_oipl_f%rowtype; -- TM added for backport of 115.6

490: l_ovn number;
491: l_dummy_dt date;
492: l_dummy_num number;
493: l_dummy_varchar varchar2(30);
494: l_oipl_rec ben_oipl_f%rowtype; -- TM added for backport of 115.6
495: l_pgm_rec ben_pgm_f%rowtype;
496:
497: l_effective_date date;
498: l_effective_date_1 date := p_effective_date - 1;