APPS.FA_GROUP_RECLASS2_PVT dependencies on FA_MC_ADJUSTMENTS

Line 477: delete from fa_mc_adjustments

473: -- a group reclass / member adjustment, etc inside
474: -- calc_fin_info when calling faxama/faxiat
475:
476: if (p_mrc_sob_type_code = 'R') then
477: delete from fa_mc_adjustments
478: where asset_id = px_src_asset_hdr_rec.asset_id
479: and book_type_code = px_src_asset_hdr_rec.book_type_code
480: and transaction_header_id = px_src_trans_rec.transaction_header_id
481: and adjustment_type in ('EXPENSE', 'BONUS EXPENSE', 'IMPAIR EXPENSE')

Line 737: delete from fa_mc_adjustments

733: -- a group reclass / member adjustment, etc inside
734: -- calc_fin_info when calling faxama/faxiat
735:
736: if (p_mrc_sob_type_code = 'R') then
737: delete from fa_mc_adjustments
738: where asset_id = px_dest_asset_hdr_rec.asset_id
739: and book_type_code = px_dest_asset_hdr_rec.book_type_code
740: and transaction_header_id = px_dest_trans_rec.transaction_header_id
741: and adjustment_type in ('EXPENSE', 'BONUS EXPENSE',

Line 1002: from fa_mc_adjustments adj

998: CURSOR c_get_mc_exp_amount IS
999: select NVL(SUM(DECODE(adj.debit_credit_flag,
1000: 'DR', adj.adjustment_amount,
1001: 'CR', -1 * adj.adjustment_amount)), 0)
1002: from fa_mc_adjustments adj
1003: where adj.asset_id = p_asset_hdr_rec.asset_id
1004: and adj.book_type_code = p_asset_hdr_rec.book_type_code
1005: and adj.adjustment_type = 'EXPENSE'
1006: and adj.period_counter_created = p_period_rec.period_counter

Line 1988: from fa_mc_adjustments adj

1984: cursor FA_ADJ_RESERVE_MRC is
1985: select sum(decode(adj.debit_credit_flag,
1986: 'DR',adj.adjustment_amount,
1987: 'CR', -1 * adj.adjustment_amount))
1988: from fa_mc_adjustments adj
1989: where adj.book_type_code = h_book_type_code
1990: and adj.asset_id = h_member_asset_id
1991: and adj.adjustment_type = 'RESERVE'
1992: and adj.source_type_code = 'ADJUSTMENT'