DBA Data[Home] [Help]

APPS.JA_CN_FA_AC_EXPORT_PKG dependencies on FA_RETIREMENTS

Line 867: FROM fa_transaction_history_trx_v fthv, fa_retirements fr

863:
864: --verify if the asset was retired during the period.
865: SELECT MIN(fthv.transaction_header_id)
866: INTO ln_retire_tran_header_id
867: FROM fa_transaction_history_trx_v fthv, fa_retirements fr
868: WHERE fthv.book_type_code = lv_book_type_code
869: AND fthv.asset_id = lv_asset_id
870: AND fthv.transaction_type_code IN
871: ('FULL RETIREMENT', 'PARTIAL RETIREMENT')