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

Line 197: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler

193: ,c_bgp_id number
194: )
195: IS
196: select max(rslt.effective_start_date)
197: from ben_prtt_enrt_rslt_f rslt,ben_ler_f ler
198: where rslt.person_id = c_per_id
199: and ler.ler_id=rslt.ler_id
200: -- and rslt.prtt_enrt_rslt_stat_cd NOT IN ('BCKDT', 'VOIDD')
201: and rslt.prtt_enrt_rslt_stat_cd is null

Line 320: FROM ben_prtt_enrt_rslt_f pen, ben_plip_f plip

316: IS
317: SELECT pen.pl_id,
318: pen.oipl_id,
319: plip.plip_id
320: FROM ben_prtt_enrt_rslt_f pen, ben_plip_f plip
321: WHERE pen.person_id = c_per_id
322: AND pen.business_group_id = c_bgp_id
323: AND pen.prtt_enrt_rslt_stat_cd IS NULL
324: --AND pen.sspndd_flag = 'N'