APPS.FA_REC_PVT_PKG1 dependencies on FA_DISTRIBUTION_HISTORY

Line 182: SELECT sum(units_assigned) FROM FA_DISTRIBUTION_HISTORY

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
183: WHERE asset_id = p_asset_id
184: AND date_ineffective is NULL;
185: BEGIN
186: -- Check from transction approval per asset. Units in asset history and