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

Line 806: from ben_ler_f ler

802: and (p_person_id is NULL or pil.person_id = p_person_id)
803: -- and (p_ler_id is NULL or pil.per_in_ler_id = p_ler_id) -- 2828045
804: and (p_ler_id is NULL or pil.ler_id = p_ler_id)
805: and exists (select null -- 2828045
806: from ben_ler_f ler
807: where ler.ler_id = pil.ler_id
808: and ler.typ_cd not in ('COMP','ABS','GSP')
809: and l_effective_date
810: between ler.effective_start_date

Line 2028: ,ben_ler_f ler

2024: ,a.enrt_perd_strt_dt
2025: ,a.enrt_perd_end_dt
2026: From Ben_pil_elctbl_chc_popl a
2027: ,ben_per_in_ler b
2028: ,ben_ler_f ler
2029: Where a.PIL_ELCTBL_POPL_STAT_CD = 'STRTD'
2030: --and a.business_group_id = b.business_group_id
2031: and a.business_group_id = p_business_group_id
2032: and a.per_in_ler_id = b.per_in_ler_id

Line 2047: ben_ler_f ler

2043: Select b.PER_IN_LER_ID
2044: ,b.lf_evt_ocrd_dt
2045: ,b.ler_id
2046: From ben_per_in_ler b,
2047: ben_ler_f ler
2048: Where b.per_in_ler_stat_cd = 'STRTD'
2049: and b.person_id = p_person_id
2050: and b.ler_id = ler.ler_id
2051: and ler.typ_cd not in ('COMP','GSP')