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_ELIG_PER_F

Line 212: ,ben_elig_per_f pep

208: cursor c_pep_pgm_defer(p_pgm_id number) is
209: --
210: select pen.*
211: from ben_prtt_enrt_rslt_f pen
212: ,ben_elig_per_f pep
213: where pen.pgm_id = p_pgm_id
214: ---Bug 7342283
215: and pen.pgm_id = pep.pgm_id
216: ----Bug 7342283

Line 232: ,ben_elig_per_f pep

228: cursor c_pep_pl_defer(p_pl_id number) is
229: --
230: select pen.*
231: from ben_prtt_enrt_rslt_f pen
232: ,ben_elig_per_f pep
233: where pen.pl_id = p_pl_id
234: and pep.pl_id = pen.pl_id
235: and pep.elig_flag = 'N'
236: and pen.pgm_id is null

Line 252: ,ben_elig_per_f pep

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
256: ----Bug 7301670

Line 282: ,ben_elig_per_f pep

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
286: and pep.pgm_id is null