APPS.FA_PROCESS_GROUPS_PKG dependencies on FA_TRX_REFERENCES

Line 267: from fa_trx_references

263: SRC_EXPENSE_AMOUNT,
264: DEST_EXPENSE_AMOUNT,
265: SRC_EOFY_RESERVE,
266: DEST_EOFY_RESERVE
267: from fa_trx_references
268: where TRX_REFERENCE_ID = l_trans_rec.trx_reference_id;
269:
270: --
271: -- Energy Enhancement.

Line 361: fa_trx_references tr --Added for bug 537059

357: , th.last_update_login
358: , th.event_id
359: , tr.transaction_type
360: from fa_transaction_headers th,
361: fa_trx_references tr --Added for bug 537059
362: where th.transaction_header_id = l_trans_rec.member_transaction_header_id
363: and tr.trx_reference_id(+) = th.trx_reference_id; --Added for bug 537059
364:
365: lm_trans_rec FA_API_TYPES.trans_rec_type;

Line 1352: from fa_trx_references

1348:
1349: --Bug6987743: Getting previously transfered reserve
1350: cursor c_get_reserve is
1351: select nvl(reserve_transfer_amount, 0)
1352: from fa_trx_references
1353: where dest_asset_id = l_src_asset_hdr_rec.asset_id
1354: and member_asset_id = p_trx_ref_rec.member_asset_id
1355: and book_type_code = p_trx_ref_rec.book_type_code
1356: order by trx_reference_id desc;

Line 2499: update fa_trx_references

2495: and book_type_code = p_trx_ref_rec.book_type_code
2496: and transaction_header_id_out is null;
2497: end if;
2498:
2499: update fa_trx_references
2500: set reserve_transfer_amount = l_group_reclass_options_rec.reserve_amount
2501: , src_expense_amount = l_group_reclass_options_rec.source_exp_amount
2502: , dest_expense_amount = l_group_reclass_options_rec.destination_exp_amount
2503: where trx_reference_id = l_src_trans_rec.trx_reference_id;