APPS.IGI_IAC_COMMON_UTILS dependencies on FA_ASSET_HISTORY

Line 257: FROM fa_asset_history h

253: END IF;
254:
255: SELECT h.units
256: INTO p_units_before
257: FROM fa_asset_history h
258: WHERE h.asset_id = P_asset_id
259: AND h.transaction_header_id_out = l_txn_id_before ;
260:
261: SELECT h.units

Line 263: FROM fa_asset_history h

259: AND h.transaction_header_id_out = l_txn_id_before ;
260:
261: SELECT h.units
262: INTO p_units_after
263: FROM fa_asset_history h
264: WHERE h.asset_id = P_asset_id
265: AND h.transaction_header_id_in = l_txn_id_before ;
266:
267: RETURN TRUE ;

Line 385: FROM fa_asset_history h

381: l_path_name := g_path||'prorate_amt_to_active_dists';
382:
383: SELECT h.units
384: INTO l_tot_units
385: FROM fa_asset_history h
386: WHERE asset_id = P_asset_id
387: AND date_ineffective IS NULL ;
388:
389: l_remain_amount := P_amount ;