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_SSPNDD_ENROLLMENT dependencies on BEN_LER_BNFT_RSTRN_F

Line 939: From ben_ler_bnft_rstrn_f

935: select 1 order_no
936: ,DFLT_TO_ASN_PNDG_CTFN_CD
937: ,DFLT_TO_ASN_PNDG_CTFN_RL
938: ,null BNFT_OR_OPTION_RSTRCTN_CD
939: From ben_ler_bnft_rstrn_f
940: Where pl_id = p_pl_id
941: and ler_id = p_ler_id
942: and l_get_lf_evt_ocrd_dt between --Bug#5402317
943: effective_start_date and effective_end_date

Line 3744: from ben_ler_bnft_rstrn_f lbr,

3740: -- RCHASE added PLIP join for unsspnd enrt cd setup at plip level
3741: cursor c_unsspnd_enrt_cd is
3742: select nvl(lbr.unsspnd_enrt_cd,
3743: nvl(pl.unsspnd_enrt_cd, plip.unsspnd_enrt_cd))
3744: from ben_ler_bnft_rstrn_f lbr,
3745: ben_pl_f pl,
3746: ben_plip_f plip
3747: where
3748: pl.pl_id=l_pen.pl_id