APPS.FA_PROCESS_GROUPS_PKG dependencies on FA_ADJUSTMENTS

Line 275: from fa_adjustments

271: -- Energy Enhancement.
272: --
273: CURSOR c_get_unplanned_amt IS
274: select adjustment_amount
275: from fa_adjustments
276: where asset_id = l_asset_hdr_rec.asset_id
277: and book_type_code = l_asset_hdr_rec.book_type_code
278: and transaction_header_id = l_trans_rec.transaction_header_id;
279:

Line 282: from fa_adjustments_mrc_v

278: and transaction_header_id = l_trans_rec.transaction_header_id;
279:
280: CURSOR c_mc_get_unplanned_amt IS
281: select adjustment_amount
282: from fa_adjustments_mrc_v
283: where asset_id = l_asset_hdr_rec.asset_id
284: and book_type_code = l_asset_hdr_rec.book_type_code
285: and transaction_header_id = l_trans_rec.transaction_header_id;
286:

Line 322: from fa_adjustments

318: CURSOR c_get_group_rsv_ret IS
319: select sum(decode(debit_credit_flag, 'CR', -1, 1) *
320: decode(l_trans_rec.transaction_key, 'MR', 1, -1) *
321: adjustment_amount)
322: from fa_adjustments
323: where asset_id = l_asset_hdr_rec.asset_id
324: and book_type_code = l_asset_hdr_rec.book_type_code
325: and transaction_header_id = l_trans_rec.transaction_header_id
326: and adjustment_type = 'RESERVE';

Line 330: from fa_adjustments_mrc_v

326: and adjustment_type = 'RESERVE';
327:
328: CURSOR c_mc_get_group_rsv_ret IS
329: select sum(decode(debit_credit_flag, 'CR', -1, 1) * adjustment_amount)
330: from fa_adjustments_mrc_v
331: where asset_id = l_asset_hdr_rec.asset_id
332: and book_type_code = l_asset_hdr_rec.book_type_code
333: and transaction_header_id = l_trans_rec.transaction_header_id
334: and adjustment_type = 'RESERVE';

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

810: end if;
811:
812:
813: --
814: -- Dupulicate group FA_ADJUSTMENTS entries on member asset
815: --
816: if (nvl(l_deprn_exp, 0) <> 0 or nvl(l_bonus_deprn_exp, 0) <> 0) and
817: (l_asset_type_rec.asset_type = 'GROUP') and
818: (l_trans_rec.member_transaction_header_id is not null) and

Line 2111: update fa_adjustments

2107: -- when it should not have been.
2108:
2109: if (l_group_reclass_code = 'NONE-GRP') then
2110:
2111: update fa_adjustments
2112: set track_member_flag = null
2113: where transaction_header_id = l_trans_rec.transaction_header_id
2114: and book_type_code = l_asset_hdr_rec.book_type_code;
2115:

Line 2128: update fa_adjustments_mrc_v

2124: and book_type_code = l_mem_asset_hdr_rec.book_type_code
2125: and transaction_type_code = 'TRANSFER'
2126: and transaction_header_id > l_mem_trans_rec.transaction_header_id;
2127:
2128: update fa_adjustments_mrc_v
2129: set track_member_flag = null
2130: where transaction_header_id = l_trans_rec.transaction_header_id
2131: and book_type_code = l_asset_hdr_rec.book_type_code;
2132: