DBA Data[Home] [Help]

APPS.FA_SORP_REVALUATION_PKG dependencies on FA_MC_ADJUSTMENTS

Line 2050: FA_MC_ADJUSTMENTS adj,

2046: sum(adj.adjustment_amount),
2047: adj.period_counter_created,
2048: fbs.reval_loss_balance
2049: FROM
2050: FA_MC_ADJUSTMENTS adj,
2051: fa_mc_books_summary fbs,
2052: fa_transaction_headers fth
2053: WHERE adj.asset_id = p_asset_hdr_rec.asset_id
2054: AND adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 2103: FA_MC_ADJUSTMENTS adj

2099:
2100: CURSOR c_mc_get_sum_reval_losses is
2101: SELECT sum(adj.adjustment_amount)
2102: FROM
2103: FA_MC_ADJUSTMENTS adj
2104: WHERE adj.asset_id = p_asset_hdr_rec.asset_id
2105: AND adj.book_type_code = p_asset_hdr_rec.book_type_code
2106: AND adj.adjustment_type = 'REVAL LOSS'
2107: AND adj.debit_credit_flag = 'DR'