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.

[Home] [Help]

APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 724: from ben_bnft_prvdd_ldgr_f bpl,

720: cursor c_bpl ( c_acty_base_rt_id number ,
721: c_bnft_prvdr_pool_id number ,
722: c_prtt_enrt_rslt_id number) is
723: select prvdd_val
724: from ben_bnft_prvdd_ldgr_f bpl,
725: ben_per_in_ler pil
726: where bpl.acty_base_rt_id = c_acty_base_rt_id
727: and bpl.bnft_prvdr_pool_id = c_bnft_prvdr_pool_id
728: and bpl.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id

Line 842: l_prvdd_val ben_bnft_prvdd_ldgr_f.prvdd_Val%type ;

838: and pyp.business_group_id = p_business_group_id
839: and p_effective_date BETWEEN yp.start_date AND yp.end_date
840: and yp.business_group_id = p_business_group_id ;
841:
842: l_prvdd_val ben_bnft_prvdd_ldgr_f.prvdd_Val%type ;
843: l_prtt_enrt_rslt_id_shell number ;
844: l_acty_ref_perd_cd varchar2(80);
845: l_acty_base_rt_id number;
846: l_bpp_rt_strt_dt date;

Line 2646: from ben_bnft_prvdd_ldgr_f bpl,

2642: bpl.bnft_prvdr_pool_id,
2643: bpl.prvdd_val,
2644: bpl.business_group_id,
2645: pil.person_id
2646: from ben_bnft_prvdd_ldgr_f bpl,
2647: ben_per_in_ler pil
2648: where bpl.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2649: and bpl.prvdd_val is not null
2650: and bpl.effective_end_date = hr_api.g_eot