APPS.FA_ADJUSTMENT_PUB dependencies on FA_MC_ADJUSTMENTS

Line 1438: delete from fa_mc_adjustments

1434: nvl(p_asset_deprn_rec_adj.deprn_reserve, 0) <> 0) then
1435:
1436: if (G_release = 11) then
1437: if (l_reporting_flag = 'R') then
1438: delete from fa_mc_adjustments
1439: where asset_id = px_asset_hdr_rec.asset_id
1440: and book_type_code = px_asset_hdr_rec.book_type_code
1441: and source_type_code = 'DEPRECIATION'
1442: and adjustment_type = 'EXPENSE'

Line 1476: from fa_mc_adjustments

1472: adj_row.mrc_sob_type_code := 0;
1473: begin
1474: select sum(decode(debit_credit_flag,'DR',adjustment_amount,-1*adjustment_amount))
1475: into l_expense_amount
1476: from fa_mc_adjustments
1477: where asset_id = px_asset_hdr_rec.asset_id
1478: and book_type_code = px_asset_hdr_rec.book_type_code
1479: and source_type_code = 'DEPRECIATION'
1480: and adjustment_type = 'EXPENSE'