DBA Data[Home] [Help]

APPS.FA_TRANSFERS_PKG dependencies on FA_ASSET_HISTORY

Line 105: from fa_asset_history

101: --
102: if X_From_Block <> 'FA_BOOKS' /* no asset_id yet for tfr in */ then
103: -- make sure units are in sync
104: select units into lv_ah_units
105: from fa_asset_history
106: where asset_id = X_Asset_Id
107: and date_ineffective is null;
108: --
109: select sum(units_assigned - nvl(transaction_units, 0))

Line 187: from fa_asset_history

183: --
184: -- used in Transfers user exit
185: select asset_type, category_id
186: into X_Asset_Type, X_Category_Id
187: from fa_asset_history
188: where asset_id = X_Asset_Id
189: and date_ineffective is null;
190: end if; /* if X_From_Block <> 'BOOKS' */
191: --