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

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

Line 414: from ben_elig_dpnt edp2

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

Line 432: ,ben_elig_dpnt edp3

428: )
429: -- bug 14757304
430: and pil.lf_evt_ocrd_dt = (select max(pil3.lf_evt_ocrd_dt)
431: from ben_per_in_ler pil3
432: ,ben_elig_dpnt edp3
433: ,ben_elig_per_elctbl_chc epe -- 16218534
434: where pil3.per_in_ler_id = edp3.per_in_ler_id
435: and edp3.dpnt_person_id = c_person_id
436: and edp3.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id -- 16218534