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
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 ;
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 ;