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 251: ,ben_oipl_f oipl

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

Line 281: ,ben_oipl_f oipl

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

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

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