APPS.CSE_ASSET_UTIL_PKG dependencies on FA_MASS_EXT_RETIREMENTS

Line 1268: FROM fa_mass_ext_retirements

1264: CURSOR ext_ret_cur (c_distribution_id IN NUMBER)
1265: IS
1266: SELECT SUM(NVL(cost_retired,0)*(-1)) cost
1267: ,SUM(NVL(units,0)*(-1)) units
1268: FROM fa_mass_ext_retirements
1269: WHERE review_status = 'POST'
1270: AND book_type_code = p_asset_query_rec.book_type_code
1271: AND asset_id = p_asset_query_rec.asset_id ;
1272: --AND distribution_id = c_distribution_id ;