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 658: ben_ler_f ler

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

Line 671: ben_ler_f ler

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

Line 684: ben_ler_f ler

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