72:
73: -- for NOCOPY.
74: l_fp_reval_exceptions := fp_reval_exceptions;
75:
76: delete from igi_iac_exceptions
77: where asset_id = fp_reval_exceptions.asset_id
78: and book_type_code = fp_reval_exceptions.book_type_code
79: and revaluation_id = fp_revaluation_id;
80:
82: into l_category_id
83: from fa_additions
84: where asset_id = fp_reval_exceptions.asset_id;
85:
86: insert into igi_iac_exceptions
87: (
88: revaluation_id ,
89: asset_id ,
90: category_id ,