APPS.FA_RETIREMENT_PVT dependencies on FA_BOOKS_SUMMARY_MRC_V

Line 4255: UPDATE FA_BOOKS_SUMMARY_MRC_V

4251: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4252: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4253: AND TRANSACTION_HEADER_ID_OUT is null;
4254:
4255: UPDATE FA_BOOKS_SUMMARY_MRC_V
4256: SET TERMINAL_GAIN_LOSS_FLAG = 'Y'
4257: WHERE ASSET_ID = p_asset_hdr_rec.asset_id
4258: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4259: AND PERIOD_COUNTER = p_period_rec.period_counter;

Line 4360: FROM FA_BOOKS_SUMMARY_MRC_V

4356: AND PERIOD_COUNTER = p_period_rec.period_counter;
4357:
4358: CURSOR C_MC_GET_BS_SUM_ADJ_COST IS
4359: SELECT SUM(ADJUSTED_COST)
4360: FROM FA_BOOKS_SUMMARY_MRC_V
4361: WHERE BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
4362: AND TRANSACTION_HEADER_ID_OUT is null
4363: AND nvl(FULLY_RESERVED_FLAG, 'N') = 'N'
4364: AND nvl(FULLY_RETIRED_FLAG, 'N') = 'N'

Line 4944: UPDATE FA_BOOKS_SUMMARY_MRC_V

4940: l_loc := 'Before BS';
4941: -- Update FA_BOOKS_SUMAMRY_MRC_V table with new reserve adjustment amount and
4942: -- related columns. Return new adjusted_cost and deprn reserve for later use
4943: FORALL i in t_asset_id.first..t_asset_id.last
4944: UPDATE FA_BOOKS_SUMMARY_MRC_V
4945: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjustment_amount(i)
4946: , DEPRN_RESERVE = DEPRN_RESERVE + t_adjustment_amount(i)
4947: , ADJUSTED_COST = RECOVERABLE_COST - DEPRN_RESERVE - t_adjustment_amount(i)
4948: WHERE ASSET_ID = t_asset_id(i)

Line 5565: UPDATE FA_BOOKS_SUMMARY_MRC_V

5561: WHERE ASSET_ID = l_last_asset_id
5562: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5563: AND TRANSACTION_HEADER_ID = l_last_thid);
5564:
5565: UPDATE FA_BOOKS_SUMMARY_MRC_V
5566: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + l_reallocate_amount
5567: , DEPRN_RESERVE = DEPRN_RESERVE + l_reallocate_amount
5568: , ADJUSTED_COST = RECOVERABLE_COST - DEPRN_RESERVE
5569: WHERE ASSET_ID = l_last_asset_id

Line 5628: UPDATE FA_BOOKS_SUMMARY_MRC_V

5624: WHERE ASSET_ID = t_asset_id(i)
5625: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5626: AND TRANSACTION_HEADER_ID = t_thid(i));
5627:
5628: UPDATE FA_BOOKS_SUMMARY_MRC_V
5629: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + l_reallocate_amount
5630: , DEPRN_RESERVE = DEPRN_RESERVE + l_reallocate_amount
5631: , ADJUSTED_COST = ADJUSTED_RECOVERABLE_COST - DEPRN_RESERVE
5632: WHERE ASSET_ID = t_asset_id(i)

Line 5690: UPDATE FA_BOOKS_SUMMARY_MRC_V

5686: WHERE ASSET_ID = t_asset_id(i)
5687: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5688: AND TRANSACTION_HEADER_ID = t_thid(i));
5689:
5690: UPDATE FA_BOOKS_SUMMARY_MRC_V
5691: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjusted_recoverable_cost(i) -
5692: t_new_deprn_reserve(i)
5693: , DEPRN_RESERVE = ADJUSTED_RECOVERABLE_COST
5694: , ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST

Line 5807: UPDATE FA_BOOKS_SUMMARY_MRC_V

5803: WHERE ASSET_ID = t_asset_id(i)
5804: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5805: AND TRANSACTION_HEADER_ID = t_thid(i));
5806:
5807: UPDATE FA_BOOKS_SUMMARY_MRC_V
5808: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + l_reallocate_amount
5809: , DEPRN_RESERVE = DEPRN_RESERVE + l_reallocate_amount
5810: , ADJUSTED_COST = ADJUSTED_RECOVERABLE_COST - DEPRN_RESERVE
5811: WHERE ASSET_ID = t_asset_id(i)

Line 5863: UPDATE FA_BOOKS_SUMMARY_MRC_V

5859: WHERE ASSET_ID = t_asset_id(i)
5860: AND BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
5861: AND TRANSACTION_HEADER_ID = t_thid(i));
5862:
5863: UPDATE FA_BOOKS_SUMMARY_MRC_V
5864: SET RESERVE_ADJUSTMENT_AMOUNT = RESERVE_ADJUSTMENT_AMOUNT + t_adjusted_cost(i)
5865: , DEPRN_RESERVE = ADJUSTED_RECOVERABLE_COST
5866: , ADJUSTED_COST = RECOVERABLE_COST - ADJUSTED_RECOVERABLE_COST
5867: WHERE ASSET_ID = t_asset_id(i)