DBA Data[Home] [Help]

APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_VRBL_RT_PRFL_F

Line 240: ben_vrbl_rt_prfl_f b

236:
237: cursor c_chk_calc (p_abr_id number ) is
238: select b.mlt_cd from
239: ben_acty_vrbl_rt_f a ,
240: ben_vrbl_rt_prfl_f b
241: where
242: a.acty_base_rt_id = p_abr_id
243: and a.vrbl_rt_prfl_id = b.vrbl_rt_prfl_id
244: and a.business_group_id =p_business_group_id

Line 250: l_mlt_cd ben_vrbl_rt_prfl_f.mlt_cd%type ;

246: and p_effective_date between b.effective_start_date and b.effective_end_date
247: and ( mlt_cd not in ('FLFX' , 'RL') or VRBL_RT_TRTMT_CD <> 'RPLC' )
248: ;
249:
250: l_mlt_cd ben_vrbl_rt_prfl_f.mlt_cd%type ;
251:
252: --
253: l_rt_ovridn_rec c_prtt_rt%rowtype;
254: l_plan_rec c_imp_inc_plan%rowtype;