APPS.FA_PROCESS_GROUPS_PKG dependencies on FA_MC_ADJUSTMENTS

Line 284: from fa_mc_adjustments

280: and transaction_header_id = l_trans_rec.transaction_header_id;
281:
282: CURSOR c_mc_get_unplanned_amt IS
283: select decode(debit_credit_flag,'DR',adjustment_amount,'CR',-1*adjustment_amount)
284: from fa_mc_adjustments
285: where asset_id = l_asset_hdr_rec.asset_id
286: and book_type_code = l_asset_hdr_rec.book_type_code
287: and transaction_header_id = l_trans_rec.transaction_header_id
288: and set_of_books_id = l_asset_hdr_rec.set_of_books_id;

Line 337: from fa_mc_adjustments

333: CURSOR c_mc_get_group_rsv_ret IS --Bug 9076882
334: select sum(decode(debit_credit_flag, 'CR', -1, 1) *
335: decode(l_trans_rec.transaction_key, 'MR', 1, -1) *
336: adjustment_amount)
337: from fa_mc_adjustments
338: where asset_id = l_asset_hdr_rec.asset_id
339: and book_type_code = l_asset_hdr_rec.book_type_code
340: and transaction_header_id = l_trans_rec.transaction_header_id
341: and adjustment_type = 'RESERVE'

Line 2396: update fa_mc_adjustments

2392: end loop;
2393:
2394: elsif (l_group_reclass_code = 'NONE-GRP') then -- reporting is implied in else
2395:
2396: update fa_mc_adjustments
2397: set track_member_flag = null
2398: where transaction_header_id in
2399: (select transaction_header_id
2400: from fa_transaction_headers th_in