APPS.IGI_IAC_COMMON_UTILS dependencies on FA_ASSET_HISTORY

Line 280: FROM fa_asset_history h

276: END IF;
277:
278: SELECT h.units
279: INTO p_units_before
280: FROM fa_asset_history h
281: WHERE h.asset_id = P_asset_id
282: AND h.transaction_header_id_out = l_txn_id_before ;
283:
284: SELECT h.units

Line 286: FROM fa_asset_history h

282: AND h.transaction_header_id_out = l_txn_id_before ;
283:
284: SELECT h.units
285: INTO p_units_after
286: FROM fa_asset_history h
287: WHERE h.asset_id = P_asset_id
288: AND h.transaction_header_id_in = l_txn_id_before ;
289:
290: RETURN TRUE ;

Line 408: FROM fa_asset_history h

404: l_path_name := g_path||'prorate_amt_to_active_dists';
405:
406: SELECT h.units
407: INTO l_tot_units
408: FROM fa_asset_history h
409: WHERE asset_id = P_asset_id
410: AND date_ineffective IS NULL ;
411:
412: l_remain_amount := P_amount ;