APPS.FA_AMORT_PVT dependencies on FA_ADJUSTMENTS

Line 5991: -- bug #7268720 To avoid extra row in fa_adjustments while reclass from grp to grp.

5987: l_processed_flag := FALSE;
5988: end if;
5989:
5990: -- bug #5768759 changes start here
5991: -- bug #7268720 To avoid extra row in fa_adjustments while reclass from grp to grp.
5992: /*if (p_trans_rec.transaction_key = 'GC') and
5993: (l_current_period_counter = l_trx_period_rec.period_counter)and
5994: (p_reclass_src_dest ='SOURCE') and
5995: (i=l_count) then

Line 7456: from fa_adjustments adj

7452: DECODE(ADJ.DEBIT_CREDIT_FLAG,
7453: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7454: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT))),
7455: 0)
7456: from fa_adjustments adj
7457: where adj.transaction_header_id = p_trans_rec.transaction_header_id
7458: and adj.asset_id = p_asset_hdr_rec.asset_id
7459: and adj.book_type_code = p_asset_hdr_rec.book_type_code;
7460:

Line 7469: from fa_adjustments_mrc_v adj

7465: DECODE(ADJ.DEBIT_CREDIT_FLAG,
7466: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7467: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT))),
7468: 0)
7469: from fa_adjustments_mrc_v adj
7470: where adj.transaction_header_id = p_trans_rec.transaction_header_id
7471: and adj.asset_id = p_asset_hdr_rec.asset_id
7472: and adj.book_type_code = p_asset_hdr_rec.book_type_code;
7473:

Line 7627: FROM FA_ADJUSTMENTS ADJ,

7623: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7624: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT)
7625: )),
7626: 0)
7627: FROM FA_ADJUSTMENTS ADJ,
7628: FA_TRANSACTION_HEADERS TH
7629: WHERE TH.ASSET_ID = p_asset_hdr_rec.asset_id
7630: AND TH.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
7631: AND TH.TRANSACTION_HEADER_ID <> p_trans_rec.transaction_header_id

Line 7714: FROM FA_ADJUSTMENTS_MRC_V ADJ,

7710: 'DR', ADJ.ADJUSTMENT_AMOUNT,
7711: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT)
7712: )),
7713: 0)
7714: FROM FA_ADJUSTMENTS_MRC_V ADJ,
7715: FA_TRANSACTION_HEADERS TH
7716: WHERE TH.ASSET_ID = p_asset_hdr_rec.asset_id
7717: AND TH.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
7718: AND TH.TRANSACTION_HEADER_ID <> p_trans_rec.transaction_header_id

Line 11635: from fa_adjustments

11631: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11632: CURSOR c_get_rsv_retired (c_transaction_header_id number) IS
11633: select sum(decode(debit_credit_flag, 'CR', -1 * adjustment_amount,
11634: adjustment_amount))
11635: from fa_adjustments
11636: where source_type_code = 'RETIREMENT'
11637: and adjustment_type = 'RESERVE'
11638: and asset_id = p_asset_hdr_rec.asset_id
11639: and book_type_code = p_asset_hdr_rec.book_type_code

Line 11649: from fa_adjustments_mrc_v

11645: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11646: CURSOR c_get_mc_rsv_retired (c_transaction_header_id number) IS
11647: select sum(decode(debit_credit_flag, 'CR', -1 * adjustment_amount,
11648: adjustment_amount))
11649: from fa_adjustments_mrc_v
11650: where source_type_code = 'RETIREMENT'
11651: and adjustment_type = 'RESERVE'
11652: and asset_id = p_asset_hdr_rec.asset_id
11653: and book_type_code = p_asset_hdr_rec.book_type_code

Line 11662: from fa_adjustments

11658: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11659: CURSOR c_get_reval_rsv (c_transaction_header_id number) IS
11660: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
11661: adjustment_amount))
11662: from fa_adjustments
11663: where source_type_code = 'REVALUATION'
11664: and adjustment_type = 'RESERVE'
11665: and asset_id = p_asset_hdr_rec.asset_id
11666: and book_type_code = p_asset_hdr_rec.book_type_code

Line 11675: from fa_adjustments_mrc_v

11671: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11672: CURSOR c_get_mc_reval_rsv (c_transaction_header_id number) IS
11673: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
11674: adjustment_amount))
11675: from fa_adjustments_mrc_v
11676: where source_type_code = 'REVALUATION'
11677: and adjustment_type = 'RESERVE'
11678: and asset_id = p_asset_hdr_rec.asset_id
11679: and book_type_code = p_asset_hdr_rec.book_type_code

Line 11688: from fa_adjustments

11684: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11685: CURSOR c_get_bonus_reval_rsv (c_transaction_header_id number) IS
11686: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
11687: adjustment_amount))
11688: from fa_adjustments
11689: where source_type_code = 'REVALUATION'
11690: and adjustment_type = 'BONUS_RESERVE'
11691: and asset_id = p_asset_hdr_rec.asset_id
11692: and book_type_code = p_asset_hdr_rec.book_type_code

Line 11701: from fa_adjustments_mrc_v

11697: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11698: CURSOR c_get_mc_bonus_reval_rsv (c_transaction_header_id number) IS
11699: select sum(decode(debit_credit_flag, 'DR', -1 * adjustment_amount,
11700: adjustment_amount))
11701: from fa_adjustments_mrc_v
11702: where source_type_code = 'REVALUATION'
11703: and adjustment_type = 'BONUS RESERVE'
11704: and asset_id = p_asset_hdr_rec.asset_id
11705: and book_type_code = p_asset_hdr_rec.book_type_code

Line 15409: FROM FA_ADJUSTMENTS_MRC_V

15405: 'CR', -1 * ADJUSTMENT_AMOUNT))),0)
15406: -- backdate amortization enhancement - end
15407: INTO l_adjustment_amount,
15408: l_rsv_amount
15409: FROM FA_ADJUSTMENTS_MRC_V
15410: WHERE asset_id = p_asset_hdr_rec.asset_id
15411: AND book_type_code = p_asset_hdr_rec.book_type_code
15412: AND period_counter_adjusted = l_amortize_per_ctr;
15413: else

Line 15428: FROM FA_ADJUSTMENTS

15424: 'CR', -1 * ADJUSTMENT_AMOUNT))),0)
15425: -- backdate amortization enhancement - end
15426: INTO l_adjustment_amount,
15427: l_rsv_amount
15428: FROM FA_ADJUSTMENTS
15429: WHERE asset_id = p_asset_hdr_rec.asset_id
15430: AND book_type_code = p_asset_hdr_rec.book_type_code
15431: AND period_counter_adjusted = l_amortize_per_ctr;
15432: end if;