DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PUB dependencies on FA_INVOICE_TRANSACTIONS

Line 3793: DELETE FROM FA_INVOICE_TRANSACTIONS

3789:
3790: /*
3791: * This needs to happen only once so do this for primary book.
3792: */
3793: DELETE FROM FA_INVOICE_TRANSACTIONS
3794: WHERE INVOICE_TRANSACTION_ID = l_invoice_transaction_id;
3795:
3796: end if; --(p_mrc_sob_type_code = 'R')
3797:

Line 6177: DELETE FROM FA_INVOICE_TRANSACTIONS

6173: WHERE ASSET_ID = l_asset_retire_rec.detail_info.asset_id
6174: AND INVOICE_TRANSACTION_ID_OUT = l_invoice_transaction_id
6175: AND FIXED_ASSETS_COST = 0;
6176:
6177: DELETE FROM FA_INVOICE_TRANSACTIONS
6178: WHERE INVOICE_TRANSACTION_ID = l_invoice_transaction_id;
6179:
6180: end if; -- (p_mrc_sob_type_code = 'R')
6181: end if; -- (l_invoice_transaction_id is not null)