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

Line 389: ben_elig_dpnt edp,

385: from ben_pl_f pln,
386: ben_plip_f cpp,
387: ben_ptip_f ctp,
388: ben_elig_per_f epo,
389: ben_elig_dpnt edp,
390: ben_per_in_ler pil,
391: per_contact_relationships pcr -- bug 6811004
392: where pln.pl_id = cpp.pl_id
393: and pln.business_group_id = c_bgp_id

Line 415: from ben_elig_dpnt edp2

411: between epo.effective_start_date and epo.effective_end_date
412: and epo.elig_flag = 'Y'
413: and edp.dpnt_inelig_flag = 'N'
414: and edp.create_dt = (select max(edp2.create_dt)
415: from ben_elig_dpnt edp2
416: ,ben_per_in_ler pil2
417: where edp2.dpnt_person_id = edp.dpnt_person_id
418: and edp2.elig_per_id = epo.elig_per_id
419: and pil2.per_in_ler_id(+)=edp2.per_in_ler_id