APPS.FA_AMORT_PVT dependencies on FA_ADJUSTMENTS_MRC_V

Line 7469: from fa_adjustments_mrc_v adj

7465: DECODE(ADJ.DEBIT_CREDIT_FLAG,
7466: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7467: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT))),
7468: 0)
7469: from fa_adjustments_mrc_v adj
7470: where adj.transaction_header_id = p_trans_rec.transaction_header_id
7471: and adj.asset_id = p_asset_hdr_rec.asset_id
7472: and adj.book_type_code = p_asset_hdr_rec.book_type_code;
7473:

Line 7714: FROM FA_ADJUSTMENTS_MRC_V ADJ,

7710: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7711: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT)
7712: )),
7713: 0)
7714: FROM FA_ADJUSTMENTS_MRC_V ADJ,
7715: FA_TRANSACTION_HEADERS TH
7716: WHERE TH.ASSET_ID = p_asset_hdr_rec.asset_id
7717: AND TH.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
7718: AND TH.TRANSACTION_HEADER_ID <> p_trans_rec.transaction_header_id

Line 11649: from fa_adjustments_mrc_v

11645: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11646: CURSOR c_get_mc_rsv_retired (c_transaction_header_id number) IS
11647: select sum(decode(debit_credit_flag, 'CR', -1 * adjustment_amount,
11648: adjustment_amount))
11649: from fa_adjustments_mrc_v
11650: where source_type_code = 'RETIREMENT'
11651: and adjustment_type = 'RESERVE'
11652: and asset_id = p_asset_hdr_rec.asset_id
11653: and book_type_code = p_asset_hdr_rec.book_type_code

Line 11675: from fa_adjustments_mrc_v

11671: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11672: CURSOR c_get_mc_reval_rsv (c_transaction_header_id number) IS
11673: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
11674: adjustment_amount))
11675: from fa_adjustments_mrc_v
11676: where source_type_code = 'REVALUATION'
11677: and adjustment_type = 'RESERVE'
11678: and asset_id = p_asset_hdr_rec.asset_id
11679: and book_type_code = p_asset_hdr_rec.book_type_code

Line 11701: from fa_adjustments_mrc_v

11697: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11698: CURSOR c_get_mc_bonus_reval_rsv (c_transaction_header_id number) IS
11699: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
11700: adjustment_amount))
11701: from fa_adjustments_mrc_v
11702: where source_type_code = 'REVALUATION'
11703: and adjustment_type = 'BONUS RESERVE'
11704: and asset_id = p_asset_hdr_rec.asset_id
11705: and book_type_code = p_asset_hdr_rec.book_type_code

Line 15409: FROM FA_ADJUSTMENTS_MRC_V

15405: 'CR', -1 * ADJUSTMENT_AMOUNT))),0)
15406: -- backdate amortization enhancement - end
15407: INTO l_adjustment_amount,
15408: l_rsv_amount
15409: FROM FA_ADJUSTMENTS_MRC_V
15410: WHERE asset_id = p_asset_hdr_rec.asset_id
15411: AND book_type_code = p_asset_hdr_rec.book_type_code
15412: AND period_counter_adjusted = l_amortize_per_ctr;
15413: else