APPS.CLN_NOTIFY_SHIPCONF_PKG dependencies on WSH_TRANSACTIONS_HISTORY
Line 85: FROM wsh_transactions_history
81:
82: BEGIN
83: SELECT entity_number
84: INTO l_entity_number 85: FROM wsh_transactions_history 86: WHERE document_number = p_delivery_doc_id
87: AND document_direction = 'O';
88:
89: IF (l_Debug_Level <= 1) THEN
Line 291: FROM wsh_transactions_history
287:
288: BEGIN
289: SELECT entity_number
290: INTO l_delivery_name 291: FROM wsh_transactions_history 292: WHERE document_number = p_delivery_name
293: AND document_direction = 'O'
294: AND rownum < 2;
295: