APPS.WSH_DOCUMENT_SETS dependencies on WSH_DOCUMENT_INSTANCES

Line 1183: FROM wsh_document_instances

1179: EXIT WHEN c_get_delivery_info%NOTFOUND;
1180:
1181: SELECT count(*)
1182: INTO l_bol_count
1183: FROM wsh_document_instances
1184: WHERE entity_name = 'WSH_DELIVERY_LEGS'
1185: AND entity_id = l_delivery_leg_id
1186: AND status <> 'CANCELLED';
1187:

Line 1256: from wsh_document_instances

1252: ELSIF document.concurrent_program_name = 'WSHRDPAK' THEN
1253:
1254: SELECT count(*)
1255: into cnt
1256: from wsh_document_instances
1257: WHERE entity_name = 'WSH_NEW_DELIVERIES'
1258: AND entity_id = l_argument(2)
1259: AND document_type = 'PACK_TYPE';
1260: