APPS.FA_INS_DETAIL_PKG dependencies on FA_TRANSACTION_HEADERS

Line 350: FROM fa_transaction_headers

346: asset_id = h_asset_id AND /* Bug 8237945 ... Since this is called only in Period of Addition,
347: and in Period of addition we always have to take
348: Distributions at the time of additions into consideration .*/
349: transaction_header_id_in = (SELECT TRANSACTION_HEADER_ID
350: FROM fa_transaction_headers
351: WHERE asset_id = h_asset_id
352: AND book_type_code = h_dist_book
353: AND transaction_type_code = 'TRANSFER IN')
354: -- date_ineffective IS NULL

Line 378: exists( SELECT 'X' FROM FA_TRANSACTION_HEADERS th

374: INTO h_total_units, h_dist_count
375: FROM fa_distribution_history dh
376: WHERE dh.book_type_code = h_dist_book AND
377: dh.asset_id = h_asset_id AND
378: exists( SELECT 'X' FROM FA_TRANSACTION_HEADERS th
379: WHERE asset_id = h_asset_id and
380: book_type_code = h_dist_book and
381: dh.transaction_header_id_in = th.transaction_header_id and
382: th.transaction_type_code = 'TRANSFER IN');

Line 419: -- from fa_transaction_headers

415:
416: -- bug# 2180468 - for performance
417: -- select min(date_effective)
418: -- into h_sysdate
419: -- from fa_transaction_headers
420: -- where book_type_code = h_book_type_code and
421: -- asset_id = h_asset_id;
422:
423: -- IF (SQL%NOTFOUND) THEN