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_DETERMINE_RATE_CHG dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 676: from ben_bnft_prvdd_ldgr_f bpl,

672: cursor c_bpl ( c_acty_base_rt_id number ,
673: c_bnft_prvdr_pool_id number ,
674: c_prtt_enrt_rslt_id number) is
675: select prvdd_val
676: from ben_bnft_prvdd_ldgr_f bpl,
677: ben_per_in_ler pil
678: where bpl.acty_base_rt_id = c_acty_base_rt_id
679: and bpl.bnft_prvdr_pool_id = c_bnft_prvdr_pool_id
680: and bpl.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id

Line 777: l_prvdd_val ben_bnft_prvdd_ldgr_f.prvdd_Val%type ;

773: l_abr c_abr%rowtype;
774: l_abr2 c_abr%rowtype;
775:
776:
777: l_prvdd_val ben_bnft_prvdd_ldgr_f.prvdd_Val%type ;
778: l_prtt_enrt_rslt_id_shell number ;
779: l_acty_ref_perd_cd varchar2(80);
780: l_acty_base_rt_id number;
781: l_bpp_rt_strt_dt date;

Line 2463: from ben_bnft_prvdd_ldgr_f bpl,

2459: bpl.bnft_prvdr_pool_id,
2460: bpl.prvdd_val,
2461: bpl.business_group_id,
2462: pil.person_id
2463: from ben_bnft_prvdd_ldgr_f bpl,
2464: ben_per_in_ler pil
2465: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2466: and bpl.prvdd_val is not null
2467: and bpl.effective_end_date = hr_api.g_eot