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
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