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.HRI_APL_DGNSTC_OPEN_ENRT dependencies on BEN_OIPL_F

Line 284: FROM ben_oipl_f cop

280: AND pet.effective_end_date
281: AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id)
282: AND NOT EXISTS (
283: SELECT 1
284: FROM ben_oipl_f cop
285: WHERE cop.pl_id = cpp.pl_id
286: AND :p_end_date BETWEEN cop.effective_start_date
287: AND cop.effective_end_date)
288: AND :p_end_date BETWEEN pgm.effective_start_date

Line 367: FROM ben_oipl_f cop, ben_enrt_ctfn_f ecf

363: AND lre.pl_id = pln.pl_id)
364: OR EXISTS /* Enrollment Certification Required - Option in Plan*/
365: (
366: SELECT 1
367: FROM ben_oipl_f cop, ben_enrt_ctfn_f ecf
368: WHERE ecf.oipl_id = cop.oipl_id
369: AND cv_end_date BETWEEN ecf.effective_start_date
370: AND ecf.effective_end_date
371: AND cv_end_date BETWEEN cop.effective_start_date

Line 377: FROM ben_oipl_f cop,

373: AND cop.pl_id = pln.pl_id)
374: OR EXISTS /* Enrollment Certification Required - Option In Plan Life Event */
375: (
376: SELECT 1
377: FROM ben_oipl_f cop,
378: ben_ler_rqrs_enrt_ctfn_f lre,
379: ben_ler_enrt_ctfn_f lnc
380: WHERE cop.pl_id = pln.pl_id
381: AND cop.oipl_id = lre.oipl_id