APPS.FA_INS_DETAIL_PKG dependencies on FA_ADJUSTMENTS

Line 453: FROM FA_ADJUSTMENTS adj,

449: GROUP BY adj.adjustment_amount,debit_credit_flag,th.transaction_header_id;
450:
451: CURSOR C_COST_TO_CLEAR IS --Bug 9142501
452: SELECT NVL(SUM(DECODE(adj.debit_credit_flag,'DR', -1 * adj.adjustment_amount, adj.adjustment_amount)),0)
453: FROM FA_ADJUSTMENTS adj,
454: FA_TRANSACTION_HEADERS th
455: WHERE adj.book_type_code(+) = h_book_type_code
456: AND adj.asset_id(+) = h_asset_id
457: AND adj.adjustment_type(+) = decode (th.transaction_type_code, 'CIP ADDITION', 'CIP COST', 'ADDITION', 'COST')