DBA Data[Home] [Help]

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: