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_LETRG_CACHE dependencies on BEN_LER_F

Line 81: from ben_ler_f ler

77: IS
78: select ler.ler_id
79: , ler.typ_cd
80: , ler.ocrd_dt_det_cd
81: from ben_ler_f ler
82: where ler.business_group_id = c_business_group_id
83: and c_effective_date between ler.effective_start_date
84: and ler.effective_end_date
85: and ( c_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )

Line 147: FROM ben_ler_f ler

143: IS
144: SELECT ler.ler_id,
145: ler.typ_cd,
146: ler.ocrd_dt_det_cd
147: FROM ben_ler_f ler
148: WHERE ler.business_group_id = c_business_group_id
149: AND c_effective_date BETWEEN ler.effective_start_date
150: AND ler.effective_end_date
151: AND ( l_status = 'I' or ler.typ_cd in ('COMP','GSP','ABS','CHECKLIST') )