APPS.FA_DELETION_PUB dependencies on FA_TRANSACTION_HEADERS

Line 396: DELETE FROM FA_TRANSACTION_HEADERS

392: DELETE FROM FA_RETIREMENTS
393: WHERE Asset_Id = px_asset_hdr_rec.asset_id
394: AND book_Type_Code = px_asset_hdr_rec.book_type_code;
395:
396: DELETE FROM FA_TRANSACTION_HEADERS
397: WHERE Asset_Id = px_asset_hdr_rec.asset_id
398: AND book_Type_Code = px_asset_hdr_rec.book_type_code;
399:
400: -- mrc

Line 530: from fa_transaction_headers th

526: --trxs in tax book, since we use the th id from corp book in such cases.
527:
528: CURSOR get_trx_id IS
529: select th.transaction_header_id, th.event_id, th.book_type_code
530: from fa_transaction_headers th
531: where th.book_type_code = px_asset_hdr_rec.book_type_code
532: and th.asset_id = px_asset_hdr_rec.asset_id
533: and th.event_id is not null
534: union

Line 537: fa_transaction_headers th, fa_book_controls bc

533: and th.event_id is not null
534: union
535: select en.source_id_int_1, ev.event_id, en.valuation_method
536: from xla_transaction_entities en, xla_events ev,
537: fa_transaction_headers th, fa_book_controls bc
538: where bc.book_class = 'TAX'
539: and bc.date_ineffective is null
540: and ev.entity_id = en.entity_id
541: and ev.application_id = 140