APPS.JA_CN_PS_FA_AC_EXP_PKG dependencies on FA_RETIREMENTS

Line 811: , fa_retirements fr

807: --verify if the asset was retired during the period.
808: SELECT MIN(fthv.transaction_header_id)
809: INTO ln_retire_tran_header_id
810: FROM fa_transaction_history_trx_v fthv
811: , fa_retirements fr
812: WHERE fthv.book_type_code = lv_book_type_code
813: AND fthv.asset_id = lv_asset_id
814: AND fthv.transaction_type_code IN
815: ( 'FULL RETIREMENT', 'PARTIAL RETIREMENT')