APPS.CSE_ASSET_UTIL_PKG dependencies on FA_MASS_EXT_RETIREMENTS

Line 1393: FROM fa_mass_ext_retirements

1389: CURSOR ext_ret_cur (c_distribution_id IN NUMBER)
1390: IS
1391: SELECT SUM(NVL(cost_retired,0)*(-1)) cost
1392: ,SUM(NVL(units,0)*(-1)) units
1393: FROM fa_mass_ext_retirements
1394: WHERE review_status = 'POST'
1395: AND book_type_code = p_asset_query_rec.book_type_code
1396: AND asset_id = p_asset_query_rec.asset_id ;
1397: --AND distribution_id = c_distribution_id ;