APPS.FA_DELETION_PUB dependencies on FA_TRANSFER_DETAILS

Line 444: DELETE FROM FA_TRANSFER_DETAILS

440:
441: -- Added transfer_header_id in the where clause
442: -- as a result of High Cost SQL drill bugfix 3116047 msiddiqu
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);