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_LER_F

Line 112: FROM ben_per_in_ler pil, ben_ler_f ler

108: ler.name,
109: pil.lf_evt_ocrd_dt,
110: ler.effective_start_date,
111: ler.effective_end_date
112: FROM ben_per_in_ler pil, ben_ler_f ler
113: WHERE pil.person_id = c_per_id
114: AND pil.business_group_id = c_bgp_id
115: AND pil.ler_id = c_ler_id
116: AND pil.per_in_ler_stat_cd = 'STRTD'

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 253: ,ben_ler_f ler

249: IS
250: SELECT MAX(pil.bckt_dt)
251: FROM ben_per_in_ler pil
252: -- CWB changes
253: ,ben_ler_f ler
254: ,ben_ptnl_ler_for_per plr
255: WHERE pil.person_id = c_per_id
256: AND pil.ler_id = ler.ler_id
257: and ler.typ_cd not in ('COMP','ABS', 'GSP', 'IREC','SCHEDDU')