DBA Data[Home] [Help]

APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_VRBL_RT_PRFL_F

Line 726: ben_vrbl_rt_prfl_f b

722:
723: cursor c_chk_calc (p_abr_id number ) is
724: select b.mlt_cd from
725: ben_acty_vrbl_rt_f a ,
726: ben_vrbl_rt_prfl_f b
727: where
728: a.acty_base_rt_id = p_abr_id
729: and a.vrbl_rt_prfl_id = b.vrbl_rt_prfl_id
730: and a.business_group_id =p_business_group_id

Line 736: l_mlt_cd ben_vrbl_rt_prfl_f.mlt_cd%type ;

732: and p_effective_date between b.effective_start_date and b.effective_end_date
733: and ( mlt_cd not in ('FLFX' , 'RL') or VRBL_RT_TRTMT_CD <> 'RPLC' )
734: ;
735:
736: l_mlt_cd ben_vrbl_rt_prfl_f.mlt_cd%type ;
737:
738: -- 8716870 code change begins
739: -- cursor used to determine l_cvg_strt_dt
740: cursor c_pil_popl