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_PER_IN_LER

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 251: FROM ben_per_in_ler pil

247: ,c_leodt date
248: )
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