APPS.FA_QUERY_BALANCES_PKG dependencies on FA_MC_ADJUSTMENTS

Line 253: FROM FA_MC_ADJUSTMENTS ADJ

249: SELECT NVL(SUM(DECODE(ADJ.DEBIT_CREDIT_FLAG,
250: 'DR', ADJ.ADJUSTMENT_AMOUNT,
251: 'CR', -1*ADJ.ADJUSTMENT_AMOUNT)), 0), 1
252: INTO h_deprn_expense_adjs, h_dummy
253: FROM FA_MC_ADJUSTMENTS ADJ
254: WHERE ADJ.ASSET_ID = x_adj_drs.asset_id
255: AND ADJ.BOOK_TYPE_CODE = x_adj_drs.book
256: AND ADJ.PERIOD_COUNTER_CREATED = h_curr_period_counter
257: AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'

Line 265: FROM FA_MC_ADJUSTMENTS ADJ

261: SELECT NVL(SUM(DECODE(ADJ.DEBIT_CREDIT_FLAG,
262: 'DR', ADJ.ADJUSTMENT_AMOUNT,
263: 'CR', -1*ADJ.ADJUSTMENT_AMOUNT)), 0), 1
264: INTO h_deprn_expense_adjs, h_dummy
265: FROM FA_MC_ADJUSTMENTS ADJ
266: WHERE ADJ.ASSET_ID = x_adj_drs.asset_id
267: AND ADJ.BOOK_TYPE_CODE = x_adj_drs.book
268: AND ADJ.PERIOD_COUNTER_CREATED = h_curr_period_counter
269: AND ADJ.SOURCE_TYPE_CODE = 'REVALUATION'

Line 1969: FROM FA_MC_ADJUSTMENTS ADJ

1965: h_cip_clearing_adjs,
1966: X_ADJ_ROW.capital_adjustment, --Bug 6666666
1967: X_ADJ_ROW.general_fund, --Bug 6666666
1968: h_num_adjs
1969: FROM FA_MC_ADJUSTMENTS ADJ
1970: WHERE ADJ.ASSET_ID in (select bk.asset_id
1971: from fa_mc_books bk
1972: where bk.book_type_code = x_adj_row.book
1973: and bk.transaction_header_id_out is null

Line 2263: FROM FA_MC_ADJUSTMENTS ADJ

2259: X_ADJ_ROW.capital_adjustment, --Bug 6666666
2260: X_ADJ_ROW.general_fund, --Bug 6666666
2261: X_ADJ_ROW.reval_loss_balance,
2262: h_num_adjs
2263: FROM FA_MC_ADJUSTMENTS ADJ
2264: WHERE ADJ.ASSET_ID = X_ADJ_ROW.asset_id AND
2265: ADJ.BOOK_TYPE_CODE = X_ADJ_ROW.book AND
2266: ADJ.PERIOD_COUNTER_CREATED > X_found_per_ctr AND
2267: DECODE(h_book_class,