DBA Data[Home] [Help]

APPS.FA_DELETION_PUB dependencies on FA_ASSET_INVOICES

Line 336: FROM FA_ASSET_INVOICES

332: -- Added as a result of High Cost SQL drill bugfix 3116047 msiddiqu
333: Cursor C1 is
334: SELECT INVOICE_TRANSACTION_ID_IN,
335: INVOICE_TRANSACTION_ID_OUT
336: FROM FA_ASSET_INVOICES
337: WHERE ASSET_ID = px_asset_hdr_rec.asset_id;
338:
339: BEGIN
340:

Line 472: DELETE FROM FA_ASSET_INVOICES

468: X_Asset_id => px_asset_hdr_rec.asset_id,
469: X_Calling_Fn => l_calling_fn
470: ,p_log_level_rec => p_log_level_rec);
471:
472: DELETE FROM FA_ASSET_INVOICES
473: WHERE Asset_Id = px_asset_hdr_rec.asset_id;
474:
475: DELETE FROM FA_MC_ASSET_INVOICES
476: WHERE Asset_Id = px_asset_hdr_rec.asset_id;