APPS.IGI_IAC_CREATE_ASSETS dependencies on FA_RETIREMENTS

Line 264: fa_retirements r

260: WHERE a.asset_id = ar.asset_id
261: AND ar. revaluation_id = p_revaluation_id)
262: AND NOT EXISTS(SELECT 'X'
263: FROM fa_transaction_headers t,
264: fa_retirements r
265: WHERE t.book_type_code = b.book_type_code
266: AND t.asset_id = a.asset_id
267: AND t.transaction_header_id = r.transaction_header_id_in
268: AND r.transaction_header_id_out IS NULL