[Home] [Help]
1615: , ret.cost_retired
1616: , nvl(ret.reserve_retired, 0)
1617: , ret.proceeds_of_sale
1618: , ret.cost_of_removal
1619: from fa_mc_retirements ret
1620: where ret.transaction_header_id_in = c_transaction_header_id
1621: and ret.transaction_header_id_out is null
1622: and ret.set_of_books_id = p_asset_hdr_rec.set_of_books_id;
1623:
1634:
1635: CURSOR c_get_mc_ret_period (c_transaction_header_id number)IS
1636: select bs.period_counter
1637: from fa_mc_books_summary bs
1638: , fa_mc_retirements rt
1639: where bs.asset_id = p_group_asset_id
1640: and bs.book_type_code = p_asset_hdr_rec.book_type_code
1641: and bs.set_of_books_id = p_asset_hdr_rec.set_of_books_id
1642: and rt.date_retired between bs.calendar_period_open_date and bs.calendar_period_close_date
2592: select ret.proceeds_of_sale
2593: , ret.cost_of_removal
2594: , -1 * nvl(ret.reserve_retired, 0)
2595: , -1 * nbv_retired
2596: from fa_mc_retirements ret
2597: where ret.transaction_header_id_in = c_transaction_header_id
2598: and ret.transaction_header_id_out is null
2599: and ret.set_of_books_id = p_asset_hdr_rec.set_of_books_id;
2600:
2619: select -1 * ret.proceeds_of_sale
2620: , -1 * ret.cost_of_removal
2621: , nvl(ret.reserve_retired, 0)
2622: , nbv_retired
2623: from fa_mc_retirements ret
2624: , fa_transaction_headers mth
2625: where mth.transaction_header_id = c_transaction_header_id
2626: and mth.asset_id = ret.asset_id
2627: and mth.book_type_code = p_asset_hdr_rec.book_type_code
3404: , nvl(ret.reserve_retired, 0)
3405: , nbv_retired
3406: , ret.recognize_gain_loss -- Added for bug 8425794 / 8244128
3407: , ret.recapture_amount
3408: from fa_mc_retirements ret
3409: , fa_transaction_headers mth
3410: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
3411: and mth.asset_id = ret.asset_id
3412: and mth.book_type_code = p_asset_hdr_rec.book_type_code
8258:
8259: CURSOR c_get_mc_ret_trx IS
8260: select nvl(sum(ret.reserve_retired), 0),
8261: nvl(sum(ret.eofy_reserve), 0)
8262: from fa_mc_retirements ret,
8263: fa_transaction_headers mth,
8264: fa_transaction_headers gth,
8265: fa_mc_book_controls mbc,
8266: fa_book_controls bc,
8679: G_TRX_TYPE_TFR_VOID)
8680: and nvl(th.amortization_start_date,
8681: th.transaction_date_entered) <= p_transaction_date_entered
8682: and not exists(select 'Exclude This Retirement'
8683: from fa_mc_retirements ret,
8684: fa_transaction_headers reith
8685: where ret.transaction_header_id_in = th.transaction_header_id
8686: and ret.transaction_header_id_out = reith.transaction_header_id
8687: and ret.set_of_books_id = p_asset_hdr_rec.set_of_books_id
12103: unrevalued_cost_retired,
12104: bonus_reserve_retired,
12105: impair_reserve_retired,
12106: null -- recognize_gain_loss
12107: from fa_mc_retirements
12108: where transaction_header_id_in = c_transaction_header_id
12109: and transaction_header_id_out is null
12110: and set_of_books_id = p_asset_hdr_rec.set_of_books_id;
12111: