DBA Data[Home] [Help]

APPS.IGI_IAC_TRANSFERS_PKG dependencies on FA_ASSET_HISTORY

Line 927: FROM fa_asset_history

923: -- find the total number of units for the asset itself ( active) (keep)
924: CURSOR c_units
925: IS
926: SELECT units
927: FROM fa_asset_history
928: WHERE asset_id = p_asset_hdr_rec.asset_id
929: AND transaction_header_id_out IS NULL;
930:
931: -- find the number of units involved in the transfer