DBA Data[Home] [Help]

APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_ACTY_VRBL_RT_F

Line 788: from ben_acty_vrbl_rt_f avr

784: )
785: is
786: select avr.creation_date,
787: avr.last_update_date
788: from ben_acty_vrbl_rt_f avr
789: where avr.vrbl_rt_prfl_id = c_vpf_id
790: and avr.ACTY_BASE_RT_ID = c_abr_id
791: and c_eff_date
792: between avr.effective_start_date

Line 4742: from ben_acty_vrbl_rt_f avr,

4738: )
4739: is
4740: select vrp.vrbl_rt_prfl_id,
4741: vrp.mlt_cd
4742: from ben_acty_vrbl_rt_f avr,
4743: ben_vrbl_rt_prfl_f vrp
4744: where vrp.vrbl_rt_prfl_stat_cd = 'A'
4745: and c_eff_date
4746: between vrp.effective_start_date