166: SELECT 'x' FROM FA_BOOKS
167: WHERE book_type_code = p_book_type_code AND asset_id = p_asset_id
168: AND rate_adjustment_factor <> 1;
169: CURSOR check_cip IS 170: SELECT 'x' FROM FA_ADDITIONS 171: WHERE asset_id = p_asset_id AND asset_type = 'CIP';
172: CURSOR check_amort_allowed IS
173: SELECT 'x' FROM FA_BOOK_CONTROLS
174: WHERE book_type_code = p_book_type_code AND amortize_flag = 'NO';