[Home] [Help]
1605: , ret.cost_retired
1606: , nvl(ret.reserve_retired, 0)
1607: , ret.proceeds_of_sale
1608: , ret.cost_of_removal
1609: from fa_retirements ret
1610: where ret.transaction_header_id_in = c_transaction_header_id
1611: and ret.transaction_header_id_out is null;
1612:
1613: CURSOR c_get_mc_ret_info (c_transaction_header_id number) IS
1625: -- Following cursors to get retirement period for reinstatement trx
1626: CURSOR c_get_ret_period (c_transaction_header_id number)IS
1627: select bs.period_counter
1628: from fa_books_summary bs
1629: , fa_retirements rt
1630: where bs.asset_id = p_group_asset_id
1631: and bs.book_type_code = p_asset_hdr_rec.book_type_code
1632: and rt.date_retired between bs.calendar_period_open_date and bs.calendar_period_close_date
1633: and rt.transaction_header_id_out = c_transaction_header_id;
2583: select ret.proceeds_of_sale
2584: , ret.cost_of_removal
2585: , -1 * nvl(ret.reserve_retired, 0)
2586: , -1 * nbv_retired
2587: from fa_retirements ret
2588: where ret.transaction_header_id_in = c_transaction_header_id
2589: and ret.transaction_header_id_out is null;
2590:
2591: CURSOR c_get_mc_ret_info (c_transaction_header_id number) IS
2606: select -1 * ret.proceeds_of_sale
2607: , -1 * ret.cost_of_removal
2608: , nvl(ret.reserve_retired, 0)
2609: , nbv_retired
2610: from fa_retirements ret
2611: , fa_transaction_headers mth
2612: where mth.transaction_header_id = c_transaction_header_id
2613: and mth.asset_id = ret.asset_id
2614: and mth.book_type_code = p_asset_hdr_rec.book_type_code
3389: , ret.reserve_retired
3390: , nbv_retired
3391: , ret.recognize_gain_loss -- Added for bug 8425794 / 8244128
3392: , ret.recapture_amount
3393: from fa_retirements ret
3394: , fa_transaction_headers mth
3395: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
3396: and mth.asset_id = ret.asset_id
3397: and mth.book_type_code = p_asset_hdr_rec.book_type_code
3514: l_nbv_retired NUMBER := 0;
3515: l_reserve_retired NUMBER;
3516: l_proceeds_of_sale NUMBER := 0;
3517: l_cost_of_removal NUMBER := 0;
3518: l_recognize_gain_loss fa_retirements.recognize_gain_loss%type; -- Added for bug 8425794 / 8244128
3519: l_recapture_amount NUMBER := 0;
3520:
3521:
3522: --+++++++++++++++ For calling faxcde +++++++++++++++
7790: -- Bug4741374: period_counter+1 is required to get the rsv from period of addition
7791: AND ADJ.PERIOD_COUNTER_CREATED = p_period_rec.period_counter + 1
7792: AND ADJ.ADJUSTMENT_TYPE in ('RESERVE', 'EXPENSE')
7793: AND not exists ( select 1 from
7794: fa_retirements ret,
7795: fa_conventions con
7796: where th.transaction_type_code in (G_TRX_TYPE_FUL_RET, G_TRX_TYPE_PAR_RET)
7797: and ret.transaction_header_id_in = th.transaction_header_id
7798: and ret.asset_id = p_asset_hdr_rec.asset_id
7899: AND ADJ.PERIOD_COUNTER_CREATED = p_period_rec.period_counter + 1
7900: AND ADJ.ADJUSTMENT_TYPE in ('RESERVE', 'EXPENSE')
7901: AND ADJ.SET_OF_BOOKS_ID = p_asset_hdr_rec.set_of_books_id
7902: AND not exists ( select 1 from
7903: fa_retirements ret,
7904: fa_conventions con
7905: where th.transaction_type_code in (G_TRX_TYPE_FUL_RET, G_TRX_TYPE_PAR_RET)
7906: and ret.transaction_header_id_in = th.transaction_header_id
7907: and ret.asset_id = p_asset_hdr_rec.asset_id
8227:
8228: CURSOR c_get_ret_trx IS
8229: select nvl(sum(ret.reserve_retired), 0),
8230: nvl(sum(ret.eofy_reserve), 0)
8231: from fa_retirements ret,
8232: fa_transaction_headers mth,
8233: fa_transaction_headers gth,
8234: fa_book_controls bc,
8235: fa_fiscal_year fy
8294:
8295: CURSOR c_get_ret_trx2 IS
8296: select nvl(sum(ret.reserve_retired), 0),
8297: nvl(sum(ret.eofy_reserve), 0)
8298: from fa_retirements ret,
8299: fa_transaction_headers th,
8300: fa_book_controls bc,
8301: fa_fiscal_year fy
8302: where th.asset_id = p_asset_hdr_rec.asset_id
8627: G_TRX_TYPE_TFR_VOID)
8628: and nvl(th.amortization_start_date,
8629: th.transaction_date_entered) <= p_transaction_date_entered
8630: and not exists(select 'Exclude This Retirement'
8631: from fa_retirements ret,
8632: fa_transaction_headers reith
8633: where ret.transaction_header_id_in = th.transaction_header_id
8634: and ret.transaction_header_id_out = reith.transaction_header_id
8635: and nvl(reith.amortization_start_date,
11738: ret.date_effective date_effective,
11739: ret.transaction_type_code transaction_type_code
11740: from fa_transaction_headers ret,
11741: fa_transaction_headers rei,
11742: fa_retirements faret
11743: where ret.asset_id = p_asset_hdr_rec.asset_id
11744: and rei.asset_id = p_asset_hdr_rec.asset_id
11745: and ret.book_type_code = p_asset_hdr_rec.book_type_code
11746: and rei.book_type_code = p_asset_hdr_rec.book_type_code
11945: th.trx_reference_id trx_reference_id,
11946: th.invoice_transaction_id,
11947: '2nd SELECT in c_get_ths_adj'
11948: from fa_transaction_headers th,
11949: fa_retirements ret,
11950: fa_conventions con,
11951: fa_calendar_periods cp,
11952: fa_calendar_periods cptrx
11953: where th.asset_id = p_asset_hdr_rec.asset_id
12078: unrevalued_cost_retired,
12079: bonus_reserve_retired,
12080: impair_reserve_retired,
12081: null -- recognize_gain_loss
12082: from fa_retirements
12083: where transaction_header_id_in = c_transaction_header_id
12084: and transaction_header_id_out is null ;
12085: -- 7130809 pulled out the below code line as this is creating
12086: -- regression for adjusted cost in fa_books. This line was
12109: and transaction_header_id_out is null
12110: and set_of_books_id = p_asset_hdr_rec.set_of_books_id;
12111:
12112: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12113: -- gets reserve retired amounts if FA_RETIREMENTS doesn't store it
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))
12123: and transaction_header_id = c_transaction_header_id;
12124:
12125: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12126: -- For MRC
12127: -- gets reserve retired amounts if FA_RETIREMENTS doesn't store it
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))
12425: -- for a reinstatement transaction
12426: CURSOR c_get_retirement_pdate IS
12427: select decode(p_asset_fin_rec_old.group_asset_id, null, con.prorate_date, ret.date_retired) prorate_date
12428: from fa_conventions con,
12429: fa_retirements ret
12430: where ret.transaction_header_id_out = p_trans_rec.transaction_header_id
12431: and ret.book_type_code = p_asset_hdr_rec.book_type_code
12432: and ret.asset_id = p_asset_hdr_rec.asset_id
12433: and ret.retirement_prorate_convention = con.prorate_convention_code
12746:
12747: begin
12748: select transaction_header_id_in
12749: into l_retirement_thid -- retirement thid
12750: from fa_retirements
12751: where asset_id = p_asset_hdr_rec.asset_id
12752: and book_type_code = p_asset_hdr_rec.book_type_code
12753: and transaction_header_id_out = l_incoming_thid;
12754: exception when others then null;
13214: from fa_calendar_periods cp,
13215: fa_book_controls bc,
13216: fa_fiscal_year fy,
13217: fa_calendar_types ct,
13218: fa_retirements ret,
13219: fa_conventions con
13220: WHERE ret.book_type_code = p_asset_hdr_rec.book_type_code
13221: and ret.asset_id = p_asset_hdr_rec.asset_id
13222: and ret.transaction_header_id_in = l_trans_rec.transaction_header_id
13238: SELECT count(th.transaction_header_id)
13239: INTO l_future_ret_count
13240: FROM fa_deprn_periods dp,
13241: fa_transaction_headers th,
13242: fa_retirements ret,
13243: fa_conventions con
13244: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
13245: and th.asset_id = p_asset_hdr_rec.asset_id
13246: and th.transaction_type_code like '%RETIREMENT'