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 210: ,ben_elig_per_f pep

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

Line 230: ,ben_elig_per_f pep

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

Line 250: ,ben_elig_per_f pep

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

Line 280: ,ben_elig_per_f pep

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