APPS.JA_CN_FA_ACS_EXPORT_PKG dependencies on FA_TRANSACTION_HEADERS

Line 120: ,fa_transaction_headers fth

116: ----------------------------------------------------------
117: AND fav.asset_id IN
118: (SELECT DISTINCT fdh.asset_id
119: FROM fa_distribution_history fdh
120: ,fa_transaction_headers fth
121: WHERE fdh.asset_id = fth.asset_id
122: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
123: AND EXISTS
124: (SELECT fdp.period_close_date