APPS.FA_INS_DETAIL_PKG dependencies on FA_MC_ADJUSTMENTS

Line 439: FROM FA_MC_ADJUSTMENTS adj,

435: ORDER BY dh.distribution_id;
436:
437: CURSOR C_MC_COST_TO_CLEAR IS --Bug 9142501
438: SELECT NVL(SUM(DECODE(adj.debit_credit_flag,'DR', -1 * adj.adjustment_amount, adj.adjustment_amount)),0)
439: FROM FA_MC_ADJUSTMENTS adj,
440: FA_TRANSACTION_HEADERS th
441: WHERE adj.book_type_code(+) = h_book_type_code
442: AND adj.asset_id(+) = h_asset_id
443: AND adj.adjustment_type(+) = decode (th.transaction_type_code, 'CIP ADDITION', 'CIP COST', 'ADDITION', 'COST')