APPS.FA_REC_PVT_PKG1 dependencies on FA_ASSET_HISTORY

Line 178: SELECT units FROM FA_ASSET_HISTORY

174: CURSOR get_lease_id IS
175: SELECT lease_id FROM FA_ADDITIONS
176: WHERE asset_id = p_asset_id;
177: CURSOR get_ah_units IS
178: SELECT units FROM FA_ASSET_HISTORY
179: WHERE asset_id = p_asset_id
180: AND date_ineffective IS NULL;
181: CURSOR get_dh_units IS
182: SELECT sum(units_assigned) FROM FA_DISTRIBUTION_HISTORY