APPS.FA_REC_PVT_PKG1 dependencies on FA_ASSET_HISTORY

Line 189: SELECT units FROM FA_ASSET_HISTORY

185: CURSOR get_lease_id IS
186: SELECT lease_id FROM FA_ADDITIONS
187: WHERE asset_id = p_asset_id;
188: CURSOR get_ah_units IS
189: SELECT units FROM FA_ASSET_HISTORY
190: WHERE asset_id = p_asset_id
191: AND date_ineffective IS NULL;
192: CURSOR get_dh_units IS
193: SELECT sum(units_assigned) FROM FA_DISTRIBUTION_HISTORY