266: -- this needs to be optimized by adding parameter to do_revaluation_asset.
267: begin
268: select dd.*
269: into l_reval_params.reval_asset_rules
270: from igi_iac_reval_asset_rules dd
271: where dd.asset_id = fp_asset_id
272: and dd.book_type_code = fp_book_type_code
273: and dd.revaluation_id = fp_revaluation_id
274: ;
605: l_reval_params.reval_control.revaluation_mode := fp_revaluation_mode;
606: begin
607: select dd.*
608: into l_reval_params.reval_asset_rules
609: from igi_iac_reval_asset_rules dd
610: where dd.asset_id = fp_asset_id
611: and dd.book_type_code = fp_book_type_code
612: and dd.revaluation_id = fp_revaluation_id
613: ;