APPS.FA_PROCESS_GROUPS_PKG dependencies on FA_ADJUSTMENTS

Line 277: from fa_adjustments

273: -- Energy Enhancement.
274: --
275: CURSOR c_get_unplanned_amt IS
276: select decode(debit_credit_flag,'DR',adjustment_amount,'CR',-1*adjustment_amount) /*Bug#9684024 */
277: from fa_adjustments
278: where asset_id = l_asset_hdr_rec.asset_id
279: and book_type_code = l_asset_hdr_rec.book_type_code
280: and transaction_header_id = l_trans_rec.transaction_header_id;
281:

Line 327: from fa_adjustments

323: CURSOR c_get_group_rsv_ret IS
324: select sum(decode(debit_credit_flag, 'CR', -1, 1) *
325: decode(l_trans_rec.transaction_key, 'MR', 1, -1) *
326: adjustment_amount)
327: from fa_adjustments
328: where asset_id = l_asset_hdr_rec.asset_id
329: and book_type_code = l_asset_hdr_rec.book_type_code
330: and transaction_header_id = l_trans_rec.transaction_header_id
331: and adjustment_type = 'RESERVE';

Line 885: -- Dupulicate group FA_ADJUSTMENTS entries on member asset

881: end if;
882:
883:
884: --
885: -- Dupulicate group FA_ADJUSTMENTS entries on member asset
886: --
887: if (nvl(l_deprn_exp, 0) <> 0 or nvl(l_bonus_deprn_exp, 0) <> 0) and
888: (l_asset_type_rec.asset_type = 'GROUP') and
889: (l_trans_rec.member_transaction_header_id is not null) and

Line 2386: update fa_adjustments

2382: -- when it should not have been.
2383:
2384: if (l_group_reclass_code = 'NONE-GRP') then
2385:
2386: update fa_adjustments
2387: set track_member_flag = null
2388: where transaction_header_id = l_trans_rec.transaction_header_id
2389: and book_type_code = l_asset_hdr_rec.book_type_code;
2390: end if;