2107: )
2108: return boolean is
2109: cursor c_check is
2110: select 'x'
2111: from igi_iac_reval_asset_rules
2112: where revaluation_factor <> 1
2113: and asset_id = fp_asset_id
2114: and book_type_code = fp_book_type_code
2115: and revaluation_id = fp_reval_id
2152: )
2153: return boolean is
2154: cursor c_check is
2155: select 'x'
2156: from igi_iac_reval_asset_rules
2157: where revaluation_factor <> 1
2158: and book_type_code = fp_book_type_code
2159: and revaluation_id = fp_reval_id;
2160: l_can_update boolean;
2308: cursor c_reval_info is
2309: select iar.revaluation_id, iar.revaluation_date
2310: , iirar.revaluation_factor
2311: from igi_iac_revaluations iar
2312: , igi_iac_reval_asset_rules iirar
2313: where iar.revaluation_id = fp_reval_id
2314: and iirar.revaluation_id = fp_reval_id
2315: and iirar.asset_id = fp_asset_id
2316: and iirar.book_type_code = iar.book_type_code