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 5964: ben_elig_dpnt edp,

5960: from ben_pl_f pln,
5961: ben_plip_f cpp,
5962: ben_ptip_f ctp,
5963: ben_elig_per_f epo,
5964: ben_elig_dpnt edp,
5965: ben_per_in_ler pil
5966: where pln.pl_id = cpp.pl_id
5967: and pln.business_group_id = c_bgp_id
5968: and c_eff_date

Line 5988: from ben_elig_dpnt edp2

5984: between epo.effective_start_date and epo.effective_end_date
5985: and epo.elig_flag = 'Y'
5986: and edp.dpnt_inelig_flag = 'N'
5987: and edp.create_dt = (select max(edp2.create_dt)
5988: from ben_elig_dpnt edp2
5989: ,ben_per_in_ler pil2
5990: where edp2.dpnt_person_id = edp.dpnt_person_id
5991: and edp2.elig_per_id = epo.elig_per_id
5992: and pil2.per_in_ler_id(+)=edp2.per_in_ler_id