DBA Data[Home] [Help]

APPS.FA_ADJUSTMENT_PUB dependencies on FA_ADJUSTMENTS

Line 1445: delete from fa_adjustments

1441: and source_type_code = 'DEPRECIATION'
1442: and adjustment_type = 'EXPENSE'
1443: and set_of_books_id = l_asset_hdr_rec.set_of_books_id;
1444: else
1445: delete from fa_adjustments
1446: where asset_id = px_asset_hdr_rec.asset_id
1447: and book_type_code = px_asset_hdr_rec.book_type_code
1448: and source_type_code = 'DEPRECIATION'
1449: and adjustment_type = 'EXPENSE';

Line 1491: from fa_adjustments

1487: adj_row.mrc_sob_type_code := 1;
1488: begin
1489: select sum(decode(debit_credit_flag,'DR',adjustment_amount,-1*adjustment_amount))
1490: into l_expense_amount
1491: from fa_adjustments
1492: where asset_id = px_asset_hdr_rec.asset_id
1493: and book_type_code = px_asset_hdr_rec.book_type_code
1494: and source_type_code = 'DEPRECIATION'
1495: and adjustment_type = 'EXPENSE';