[Home] [Help]
567:
568: SELECT cost_retired,date_retired
569: INTO p_amount,p_date_retired
570: FROM fa_transaction_headers b,
571: fa_retirements a
572: WHERE a.book_type_code = p_book_type_code
573: AND a.asset_id = p_asset_id
574: AND a.status = 'DELETED'
575: AND b.book_type_code = a.book_type_code