APPS.FA_REC_PVT_PKG1 dependencies on FA_DISTRIBUTION_HISTORY

Line 193: SELECT sum(units_assigned) FROM FA_DISTRIBUTION_HISTORY

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
194: WHERE asset_id = p_asset_id
195: AND date_ineffective is NULL;
196: BEGIN
197: -- Check from transction approval per asset. Units in asset history and