DBA Data[Home] [Help]

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