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_ENROLMENT_REQUIREMENTS1 dependencies on BEN_PRTT_ENRT_RSLT_F

Line 450: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler

446: is
447: select /*+ c_getpenesd ben_enrolment_requirements1 */
448: rslt.effective_start_date,
449: rslt.enrt_cvg_thru_dt
450: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler
451: where rslt.person_id = c_per_id
452: and ler.ler_id=rslt.ler_id
453: and rslt.prtt_enrt_rslt_stat_cd is null
454: and ler.typ_cd not in ('COMP','ABS', 'GSP', 'IREC','SCHEDDU' )

Line 564: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler

560: --however he wanted this to be removed so that self service open enrollment
561: --will not be impacted and asked find ways to show history on enrollment results later
562: cursor c_get_latest_enrt_dt is
563: select max(rslt.effective_start_date)
564: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler
565: where rslt.person_id = p_person_id
566: and ler.ler_id=rslt.ler_id
567: -- and rslt.prtt_enrt_rslt_stat_cd NOT IN ('BCKDT', 'VOIDD')
568: and rslt.prtt_enrt_rslt_stat_cd is null