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_NEWLY_INELIGIBLE dependencies on BEN_LER_F

Line 660: ben_ler_f ler

656: --
657: cursor c_per_in_ler is
658: select pil.lf_evt_ocrd_dt, ler.typ_cd
659: from ben_per_in_ler pil,
660: ben_ler_f ler
661: where pil.per_in_ler_id = l_per_in_ler_id
662: and pil.ler_id = ler.ler_id
663: and p_effective_date between ler.effective_start_date and
664: ler.effective_end_date;

Line 673: ben_ler_f ler

669: --
670: cursor c_procd_dt_pil is
671: select pil.procd_dt
672: from ben_per_in_ler pil,
673: ben_ler_f ler
674: where pil.person_id = p_person_id
675: and pil.per_in_ler_id <> l_per_in_ler_id
676: and pil.per_in_ler_stat_cd = 'PROCD'
677: and pil.ler_id = ler.ler_id

Line 686: ben_ler_f ler

682:
683: cursor c_procd_dt_pil_cwb is
684: select pil.procd_dt
685: from ben_per_in_ler pil,
686: ben_ler_f ler
687: where pil.person_id = p_person_id
688: and pil.per_in_ler_id <> l_per_in_ler_id
689: and pil.per_in_ler_stat_cd = 'PROCD'
690: and pil.ler_id = ler.ler_id