APPS.FA_PROCESS_GROUPS_PKG dependencies on FA_TRX_REFERENCES

Line 269: from fa_trx_references

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

Line 369: fa_trx_references tr --Added for bug 537059

365: , th.last_update_login
366: , th.event_id
367: , tr.transaction_type
368: from fa_transaction_headers th,
369: fa_trx_references tr --Added for bug 537059
370: where th.transaction_header_id = l_trans_rec.member_transaction_header_id
371: and tr.trx_reference_id(+) = th.trx_reference_id; --Added for bug 537059
372:
373:

Line 419: FROM FA_TRX_REFERENCES

415: TRX_REFERENCE_ID,
416: EVENT_ID,
417: TRANSACTION_TYPE,
418: INVOICE_TRANSACTION_ID
419: FROM FA_TRX_REFERENCES
420: WHERE SRC_TRANSACTION_HEADER_ID = P_TRX_NUMBER;
421:
422: CURSOR c_inv_tbl IS
423: SELECT PO_VENDOR_ID,

Line 1543: from fa_trx_references

1539:
1540: --Bug6987743: Getting previously transfered reserve
1541: cursor c_get_reserve is
1542: select nvl(reserve_transfer_amount, 0)
1543: from fa_trx_references
1544: where dest_asset_id = l_src_asset_hdr_rec.asset_id
1545: and member_asset_id = p_trx_ref_rec.member_asset_id
1546: and book_type_code = p_trx_ref_rec.book_type_code
1547: order by trx_reference_id desc;

Line 2853: update fa_trx_references

2849: and book_type_code = p_trx_ref_rec.book_type_code
2850: and transaction_header_id_out is null;
2851: end if;
2852:
2853: update fa_trx_references
2854: set reserve_transfer_amount = l_group_reclass_options_rec(l_sob_index).reserve_amount
2855: , src_expense_amount = l_group_reclass_options_rec(l_sob_index).source_exp_amount
2856: , dest_expense_amount = l_group_reclass_options_rec(l_sob_index).destination_exp_amount
2857: where trx_reference_id = l_src_trans_rec.trx_reference_id;