[Home] [Help]
7571: DECODE(ADJ.DEBIT_CREDIT_FLAG,
7572: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7573: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT))),
7574: 0)
7575: from fa_mc_adjustments adj
7576: where adj.transaction_header_id = p_trans_rec.transaction_header_id
7577: and adj.asset_id = p_asset_hdr_rec.asset_id
7578: and adj.book_type_code = p_asset_hdr_rec.book_type_code
7579: and adj.set_of_books_id = p_asset_hdr_rec.set_of_books_id;
7880: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7881: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT)
7882: )),
7883: 0)
7884: FROM FA_MC_ADJUSTMENTS ADJ,
7885: FA_TRANSACTION_HEADERS TH
7886: WHERE TH.ASSET_ID = p_asset_hdr_rec.asset_id
7887: AND TH.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
7888: AND TH.TRANSACTION_HEADER_ID <> p_trans_rec.transaction_header_id
12128: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12129: CURSOR c_get_mc_rsv_retired (c_transaction_header_id number) IS
12130: select sum(decode(debit_credit_flag, 'CR', -1 * adjustment_amount,
12131: adjustment_amount))
12132: from fa_mc_adjustments
12133: where source_type_code = 'RETIREMENT'
12134: and adjustment_type = 'RESERVE'
12135: and asset_id = p_asset_hdr_rec.asset_id
12136: and book_type_code = p_asset_hdr_rec.book_type_code
12155: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12156: CURSOR c_get_mc_reval_rsv (c_transaction_header_id number) IS
12157: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
12158: adjustment_amount))
12159: from fa_mc_adjustments
12160: where source_type_code = 'REVALUATION'
12161: and adjustment_type = 'RESERVE'
12162: and asset_id = p_asset_hdr_rec.asset_id
12163: and book_type_code = p_asset_hdr_rec.book_type_code
12182: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12183: CURSOR c_get_mc_bonus_reval_rsv (c_transaction_header_id number) IS
12184: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
12185: adjustment_amount))
12186: from fa_mc_adjustments
12187: where source_type_code = 'REVALUATION'
12188: and adjustment_type = 'BONUS RESERVE'
12189: and asset_id = p_asset_hdr_rec.asset_id
12190: and book_type_code = p_asset_hdr_rec.book_type_code
12209: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12210: CURSOR c_get_mc_impair_reval_rsv (c_transaction_header_id number) IS
12211: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
12212: adjustment_amount))
12213: from fa_mc_adjustments
12214: where source_type_code = 'REVALUATION'
12215: and adjustment_type = 'IMPAIR RESERVE'
12216: and asset_id = p_asset_hdr_rec.asset_id
12217: and book_type_code = p_asset_hdr_rec.book_type_code
12238: CURSOR c_get_mc_impair_rsv (c_transaction_header_id number,
12239: c_source_type_code varchar2) IS
12240: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
12241: adjustment_amount))
12242: from fa_mc_adjustments
12243: where source_type_code = c_source_type_code
12244: and adjustment_type = 'IMPAIR RESERVE'
12245: and asset_id = p_asset_hdr_rec.asset_id
12246: and book_type_code = p_asset_hdr_rec.book_type_code
12266: CURSOR c_get_mc_impair_exp (c_transaction_header_id number,
12267: c_source_type_code varchar2) IS
12268: select nvl(sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
12269: adjustment_amount)),0)
12270: from fa_mc_adjustments
12271: where source_type_code = c_source_type_code
12272: and adjustment_type = 'IMPAIR EXPENSE'
12273: and asset_id = p_asset_hdr_rec.asset_id
12274: and book_type_code = p_asset_hdr_rec.book_type_code
16512: 'CR', -1 * ADJUSTMENT_AMOUNT))),0)
16513: -- backdate amortization enhancement - end
16514: INTO l_adjustment_amount,
16515: l_rsv_amount
16516: FROM FA_MC_ADJUSTMENTS
16517: WHERE asset_id = p_asset_hdr_rec.asset_id
16518: AND book_type_code = p_asset_hdr_rec.book_type_code
16519: AND period_counter_adjusted = l_amortize_per_ctr
16520: AND SET_OF_BOOKS_ID = p_asset_hdr_rec.set_of_books_id;