APPS.CSE_ASSET_UTIL_PKG dependencies on FA_RETIREMENTS

Line 1383: FROM fa_retirements fr ,

1379: SELECT SUM(DECODE(fr.status,'PENDING', NVL(fr.cost_retired,0)*(-1),
1380: NVL(fr.cost_retired,0))) cost,
1381: SUM(DECODE(fr.status,'PENDING', NVL(fr.units,0)*(-1),
1382: NVL(fr.units,0))) units
1383: FROM fa_retirements fr ,
1384: fa_distribution_history fdh
1385: WHERE fr.status IN ('PENDING','REINSTATE')
1386: AND fr.retirement_id = fdh.retirement_id
1387: AND fdh.distribution_id = c_distribution_id ;