APPS.INV_ROI_INTEGRATION_GRP dependencies on RCV_TRANSACTIONS_INTERFACE

Line 573: FROM rcv_transactions_interface

569: IF p_rti_id IS NOT NULL THEN
570: print_debug('Get transaction details ' , 1);
571: SELECT transaction_type, destination_type_code, auto_transact_code, parent_transaction_id
572: INTO l_transaction_type, l_destination_type_code, l_auto_transact_code, l_parent_transaction_id
573: FROM rcv_transactions_interface
574: WHERE interface_transaction_id = p_rti_id;
575: END IF;
576:
577: IF l_parent_transaction_id IS NOT NULL OR l_parent_transaction_id <> -1 THEN

Line 767: FROM RCV_TRANSACTIONS_INTERFACE

763:
764: ------------------fetching PARENT_TRANSACTION_ID
765: SELECT PARENT_TRANSACTION_ID
766: INTO l_parent_trx_id
767: FROM RCV_TRANSACTIONS_INTERFACE
768: WHERE INTERFACE_TRANSACTION_ID = p_rti_id;
769:
770: IF l_parent_trx_id IS NULL THEN
771: IF g_debug = 1 THEN