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 995: From ben_ler_bnft_rstrn_f

991: select 1 order_no
992: ,DFLT_TO_ASN_PNDG_CTFN_CD
993: ,DFLT_TO_ASN_PNDG_CTFN_RL
994: ,null BNFT_OR_OPTION_RSTRCTN_CD
995: From ben_ler_bnft_rstrn_f
996: Where pl_id = p_pl_id
997: and ler_id = p_ler_id
998: and l_get_lf_evt_ocrd_dt between --Bug#5402317
999: effective_start_date and effective_end_date

Line 3913: from ben_ler_bnft_rstrn_f lbr,

3909: -- RCHASE added PLIP join for unsspnd enrt cd setup at plip level
3910: cursor c_unsspnd_enrt_cd is
3911: select nvl(lbr.unsspnd_enrt_cd,
3912: nvl(pl.unsspnd_enrt_cd, plip.unsspnd_enrt_cd))
3913: from ben_ler_bnft_rstrn_f lbr,
3914: ben_pl_f pl,
3915: ben_plip_f plip
3916: where
3917: pl.pl_id=l_pen.pl_id