DBA Data[Home] [Help]

APPS.FA_PROCESS_GROUPS_PKG dependencies on FA_ADJUSTMENTS_MRC_V

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 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 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: