DBA Data[Home] [Help]

APPS.IGI_IAC_RETIREMENT dependencies on FA_ASSET_HISTORY

Line 87: FROM fa_asset_history

83: AND old.distribution_id = p_old_distribution ;
84:
85: CURSOR c_total_units (p_c_asset_id NUMBER) IS
86: SELECT units
87: FROM fa_asset_history
88: WHERE asset_id = p_c_asset_id
89: AND transaction_header_id_out IS NULL ;
90:
91: CURSOR c_previous_per (p_adjustment_id NUMBER) IS