APPS.WSH_TRANSACTIONS_TPW_UTIL dependencies on WSH_NEW_DEL_INTERFACE

Line 707: wsh_new_del_interface wndi

703: wth.Trading_Partner_ID,
704: wth.Transaction_Status,
705: wndi.client_code
706: FROM wsh_transactions_history wth,
707: wsh_new_del_interface wndi
708: WHERE wth.Transaction_ID = (SELECT MAX (Transaction_ID)
709: FROM wsh_transactions_history
710: WHERE Document_Number = c_Orig_Document_Number
711: AND Trading_Partner_ID = c_Trading_Partner_ID

Line 727: FROM wsh_new_del_interface

723:
724: CURSOR l_new_del_interface_cur ( c_Name VARCHAR2,
725: c_Org_ID NUMBER ) IS
726: SELECT Delivery_Interface_id
727: FROM wsh_new_del_interface
728: WHERE Name = c_Name
729: AND Organization_ID = c_Org_ID;
730: */
731:

Line 793: -- Get the Delivery Interface ID from wsh_new_del_interface table for the given record

789: IF (l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
790: RAISE wsh_get_txns_hist_error;
791: END IF;
792:
793: -- Get the Delivery Interface ID from wsh_new_del_interface table for the given record
794: -- in the transaction history table.
795: /*
796: OPEN l_new_del_interface_cur ( l_txn_hist_record.Entity_Number,
797: l_txn_hist_record.Trading_Partner_ID );