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_EVALUATE_RATE_PROFILES dependencies on BEN_ELIG_DPNT

Line 6021: ben_elig_dpnt edp,

6017: from ben_pl_f pln,
6018: ben_plip_f cpp,
6019: ben_ptip_f ctp,
6020: ben_elig_per_f epo,
6021: ben_elig_dpnt edp,
6022: ben_per_in_ler pil
6023: where pln.pl_id = cpp.pl_id
6024: and pln.business_group_id = c_bgp_id
6025: and c_eff_date

Line 6045: from ben_elig_dpnt edp2

6041: between epo.effective_start_date and epo.effective_end_date
6042: and epo.elig_flag = 'Y'
6043: and edp.dpnt_inelig_flag = 'N'
6044: and edp.create_dt = (select max(edp2.create_dt)
6045: from ben_elig_dpnt edp2
6046: ,ben_per_in_ler pil2
6047: where edp2.dpnt_person_id = edp.dpnt_person_id
6048: and edp2.elig_per_id = epo.elig_per_id
6049: and pil2.per_in_ler_id(+)=edp2.per_in_ler_id