1171: adj_row.mrc_sob_type_code := 0;
1172: begin
1173: select sum(decode(debit_credit_flag,'DR',adjustment_amount,-1*adjustment_amount))
1174: into l_expense_amount
1175: from fa_adjustments_mrc_v
1176: where asset_id = px_asset_hdr_rec.asset_id
1177: and book_type_code = px_asset_hdr_rec.book_type_code
1178: and source_type_code = 'DEPRECIATION'
1179: and adjustment_type = 'EXPENSE';
1181: when no_data_found then
1182: null;
1183: end;
1184: /*
1185: delete from fa_adjustments_mrc_v
1186: where asset_id = px_asset_hdr_rec.asset_id
1187: and book_type_code = px_asset_hdr_rec.book_type_code
1188: and source_type_code = 'DEPRECIATION'
1189: and adjustment_type = 'EXPENSE';