APPS.IGI_IAC_CREATE_ASSETS dependencies on FA_RETIREMENTS

Line 287: fa_retirements r

283: WHERE a.asset_id = ar.asset_id
284: AND ar. revaluation_id = p_revaluation_id)
285: AND NOT EXISTS(SELECT 'X'
286: FROM fa_transaction_headers t,
287: fa_retirements r
288: WHERE t.book_type_code = b.book_type_code
289: AND t.asset_id = a.asset_id
290: AND t.transaction_header_id = r.transaction_header_id_in
291: AND r.transaction_header_id_out IS NULL