APPS.FA_DELETION_PUB dependencies on FA_DISTRIBUTION_HISTORY

Line 447: FROM FA_DISTRIBUTION_HISTORY

443:
444: DELETE FROM FA_TRANSFER_DETAILS
445: WHERE ( DISTRIBUTION_ID, transfer_header_id) IN
446: ( SELECT DISTRIBUTION_ID, transaction_header_id_in transfer_header_id
447: FROM FA_DISTRIBUTION_HISTORY
448: WHERE ASSET_ID = px_asset_hdr_rec.asset_id);
449:
450: -- BUG# 4173695
451: -- removing this for performance and because invoice

Line 460: DELETE FROM FA_DISTRIBUTION_HISTORY

456: -- WHERE INVOICE_TRANSACTION_ID = C1_rec.INVOICE_TRANSACTION_ID_IN
457: -- OR INVOICE_TRANSACTION_ID = C1_rec.INVOICE_TRANSACTION_ID_OUT;
458: -- End Loop;
459:
460: DELETE FROM FA_DISTRIBUTION_HISTORY
461: WHERE Asset_Id = px_asset_hdr_rec.asset_id;
462:
463: DELETE FROM FA_ASSET_HISTORY
464: WHERE Asset_Id = px_asset_hdr_rec.asset_id;