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_EXT_ENRT dependencies on BEN_PER_IN_LER

Line 551: from ben_per_in_ler pil,

547: pil.ntfn_dt,
548: pil.ler_id,
549: pil.per_in_ler_stat_cd,
550: ler.name ler_name
551: from ben_per_in_ler pil,
552: ben_ler_f ler
553: where pil.per_in_ler_id = p_pil_id
554: and ler.ler_id = pil.ler_id
555: and p_effective_date between ler.effective_start_date and ler.effective_end_date

Line 716: ben_per_in_ler pil

712: select
713: sum(ppr.std_prem_val)
714: , ppr.std_prem_uom
715: from ben_prtt_prem_f ppr,
716: ben_per_in_ler pil
717: where ppr.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
718: and p_effective_date between nvl(ppr.effective_start_date, p_effective_date)
719: and nvl(ppr.effective_end_date, p_effective_date)
720: and pil.per_in_ler_id=ppr.per_in_ler_id