316: AND ith.asset_id = p_asset_id
317: AND (ith.transaction_type_code = 'ADDITION' AND ith.Transaction_sub_type ='REVALUATION');
318:
319: /* Cursor to get cost and salvage value for the asset from FA */
320: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS
321: SELECT salvage_value,cost
322: FROM fa_books
323: WHERE book_type_code = p_book_type_code
324: AND asset_id = p_asset_id
318:
319: /* Cursor to get cost and salvage value for the asset from FA */
320: CURSOR c_fa_books(p_asset_id fa_books.asset_id%TYPE) IS
321: SELECT salvage_value,cost
322: FROM fa_books
323: WHERE book_type_code = p_book_type_code
324: AND asset_id = p_asset_id
325: AND transactioN_header_id_out is NULL ;
326:
612: /*Salavge value correction*/
613: -- resreve
614: IF (p_salvage_value Is Null) Or (P_cost is Null) THEN
615:
616: OPEN c_fa_books(p_asset_id);
617: FETCH c_fa_books into l_salvage_value,
618: l_cost;
619: CLOSE c_fa_books;
620: ELSE
613: -- resreve
614: IF (p_salvage_value Is Null) Or (P_cost is Null) THEN
615:
616: OPEN c_fa_books(p_asset_id);
617: FETCH c_fa_books into l_salvage_value,
618: l_cost;
619: CLOSE c_fa_books;
620: ELSE
621: l_salvage_value := p_salvage_value;
615:
616: OPEN c_fa_books(p_asset_id);
617: FETCH c_fa_books into l_salvage_value,
618: l_cost;
619: CLOSE c_fa_books;
620: ELSE
621: l_salvage_value := p_salvage_value;
622: l_cost := P_cost;
623: END IF;