[Home] [Help]
7558: DECODE(ADJ.DEBIT_CREDIT_FLAG,
7559: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7560: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT))),
7561: 0)
7562: from fa_adjustments adj
7563: where adj.transaction_header_id = p_trans_rec.transaction_header_id
7564: and adj.asset_id = p_asset_hdr_rec.asset_id
7565: and adj.book_type_code = p_asset_hdr_rec.book_type_code;
7566:
7772: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7773: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT)
7774: )),
7775: 0)
7776: FROM FA_ADJUSTMENTS ADJ,
7777: FA_TRANSACTION_HEADERS TH
7778: WHERE TH.ASSET_ID = p_asset_hdr_rec.asset_id
7779: AND TH.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
7780: AND TH.TRANSACTION_HEADER_ID <> p_trans_rec.transaction_header_id
12114: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12115: CURSOR c_get_rsv_retired (c_transaction_header_id number) IS
12116: select sum(decode(debit_credit_flag, 'CR', -1 * adjustment_amount,
12117: adjustment_amount))
12118: from fa_adjustments
12119: where source_type_code = 'RETIREMENT'
12120: and adjustment_type = 'RESERVE'
12121: and asset_id = p_asset_hdr_rec.asset_id
12122: and book_type_code = p_asset_hdr_rec.book_type_code
12142: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12143: CURSOR c_get_reval_rsv (c_transaction_header_id number) IS
12144: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
12145: adjustment_amount))
12146: from fa_adjustments
12147: where source_type_code = 'REVALUATION'
12148: and adjustment_type = 'RESERVE'
12149: and asset_id = p_asset_hdr_rec.asset_id
12150: and book_type_code = p_asset_hdr_rec.book_type_code
12169: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12170: CURSOR c_get_bonus_reval_rsv (c_transaction_header_id number) IS
12171: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
12172: adjustment_amount))
12173: from fa_adjustments
12174: where source_type_code = 'REVALUATION'
12175: and adjustment_type = 'BONUS RESERVE'
12176: and asset_id = p_asset_hdr_rec.asset_id
12177: and book_type_code = p_asset_hdr_rec.book_type_code
12196: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12197: CURSOR c_get_impair_reval_rsv (c_transaction_header_id number) IS
12198: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
12199: adjustment_amount))
12200: from fa_adjustments
12201: where source_type_code = 'REVALUATION'
12202: and adjustment_type = 'IMPAIR RESERVE'
12203: and asset_id = p_asset_hdr_rec.asset_id
12204: and book_type_code = p_asset_hdr_rec.book_type_code
12224: CURSOR c_get_impair_rsv (c_transaction_header_id number,
12225: c_source_type_code varchar2) IS
12226: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
12227: adjustment_amount))
12228: from fa_adjustments
12229: where source_type_code = c_source_type_code
12230: and adjustment_type = 'IMPAIR RESERVE'
12231: and asset_id = p_asset_hdr_rec.asset_id
12232: and book_type_code = p_asset_hdr_rec.book_type_code
12252: CURSOR c_get_impair_exp (c_transaction_header_id number,
12253: c_source_type_code varchar2) IS
12254: select nvl(sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
12255: adjustment_amount)),0)
12256: from fa_adjustments
12257: where source_type_code = c_source_type_code
12258: and adjustment_type = 'IMPAIR EXPENSE'
12259: and asset_id = p_asset_hdr_rec.asset_id
12260: and book_type_code = p_asset_hdr_rec.book_type_code
16532: 'CR', -1 * ADJUSTMENT_AMOUNT))),0)
16533: -- backdate amortization enhancement - end
16534: INTO l_adjustment_amount,
16535: l_rsv_amount
16536: FROM FA_ADJUSTMENTS
16537: WHERE asset_id = p_asset_hdr_rec.asset_id
16538: AND book_type_code = p_asset_hdr_rec.book_type_code
16539: AND period_counter_adjusted = l_amortize_per_ctr;
16540: end if;