APPS.IGI_IAC_DEPRN_PKG dependencies on FA_ASSET_HISTORY
Line 1342: FROM fa_asset_history a
1338: -- get the category ID for the asset
1339:
1340: SELECT a.category_id
1341: INTO l_category_id 1342: FROM fa_asset_history a 1343: ,fa_distribution_history d
1344: WHERE d.distribution_id = l_dist_id(l_loop_count)
1345: AND a.asset_id = d.asset_id
1346: AND d.date_effective >= a.date_effective