APPS.FA_DELETION_PUB dependencies on FA_ASSET_INVOICES

Line 314: FROM FA_ASSET_INVOICES

310: -- Added as a result of High Cost SQL drill bugfix 3116047 msiddiqu
311: Cursor C1 is
312: SELECT INVOICE_TRANSACTION_ID_IN,
313: INVOICE_TRANSACTION_ID_OUT
314: FROM FA_ASSET_INVOICES
315: WHERE ASSET_ID = px_asset_hdr_rec.asset_id;
316:
317: BEGIN
318:

Line 460: DELETE FROM FA_ASSET_INVOICES

456: (X_Rowid => l_rowid,
457: X_Asset_id => px_asset_hdr_rec.asset_id,
458: X_Calling_Fn => l_calling_fn, p_log_level_rec => p_log_level_rec);
459:
460: DELETE FROM FA_ASSET_INVOICES
461: WHERE Asset_Id = px_asset_hdr_rec.asset_id;
462:
463: DELETE FROM FA_MC_ASSET_INVOICES
464: WHERE Asset_Id = px_asset_hdr_rec.asset_id;