[Home] [Help]
385: SET fr.itc_recaptured = h_recaptured,
386: fr.itc_recapture_id = h_itc_recapture_id
387: WHERE fr.retirement_id = h_retirement_id;
388: else
389: UPDATE fa_retirements_mrc_v fr
390: SET fr.itc_recaptured = h_recaptured,
391: fr.itc_recapture_id = h_itc_recapture_id
392: WHERE fr.retirement_id = h_retirement_id;
393: end if;
890: fr.last_updated_by = h_user_id
891: WHERE
892: fr.retirement_id = h_retirement_id;
893: else
894: UPDATE fa_retirements_mrc_v fr
895: SET fr.nbv_retired = h_nbv_retired,
896: fr.gain_loss_amount = h_gain_loss,
897: fr.stl_deprn_amount = h_stl_deprn,
898: fr.reval_reserve_retired = h_reval_rsv_retired,