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_ELIG_PER_ELC_CHC_API dependencies on BEN_PER_IN_LER

Line 2189: ben_per_in_ler pil1,

2185: select per1.full_name person1,
2186: per2.full_name person2
2187: from ben_cwb_mgr_hrchy cwb1,
2188: ben_elig_per_elctbl_chc epe1,
2189: ben_per_in_ler pil1,
2190: per_all_people_f per1,
2191: per_all_people_f per2
2192: where cwb1.mgr_elig_per_elctbl_chc_id = p_emp_epe_id
2193: and cwb1.lvl_num > 0

Line 2205: ben_per_in_ler pil2

2201: and per2.effective_end_date
2202: and exists
2203: ( select 'x'
2204: from ben_elig_per_elctbl_chc epe2,
2205: ben_per_in_ler pil2
2206: where pil2.person_id = p_new_mgr_id
2207: and pil2.lf_evt_ocrd_dt = pil1.lf_evt_ocrd_dt
2208: and pil2.ler_id = pil1.ler_id
2209: and epe2.per_in_ler_id = pil2.per_in_ler_id