DBA Data[Home] [Help]

APPS.FA_GAINLOSS_DPR_PKG dependencies on FA_ADJUSTMENTS

Line 459: from fa_adjustments

455: and outbk.transaction_header_id_out = ret.th_id_in;
456:
457: CURSOR c_get_rsv_ret IS
458: select sum(decode(debit_credit_flag, 'CR', -1, 1) * adjustment_amount)
459: from fa_adjustments
460: where asset_id = ret.asset_id
461: and book_type_code = ret.book
462: and source_type_code = 'RETIREMENT'
463: and adjustment_type = 'RESERVE'

Line 468: from fa_adjustments_mrc_v

464: and transaction_header_id = ret.th_id_in;
465:
466: CURSOR c_get_rsv_ret_mrc IS
467: select sum(decode(debit_credit_flag, 'CR', -1, 1) * adjustment_amount)
468: from fa_adjustments_mrc_v
469: where asset_id = ret.asset_id
470: and book_type_code = ret.book
471: and source_type_code = 'RETIREMENT'
472: and adjustment_type = 'RESERVE'