1094: FROM OE_HEADERS_IFACE_ALL b
1095: WHERE batch_id = p_batch_id and
1096: b.shipping_method_code IS NOT NULL and
1097: NOT EXISTS (select LOOKUP_CODE
1098: FROM OE_SHIP_METHODS_V
1099: WHERE lookup_code = b.shipping_method_code
1100: AND SYSDATE <= NVL(END_DATE_ACTIVE, SYSDATE))
1101: ;
1102:
1132: FROM OE_HEADERS_IFACE_ALL
1133: WHERE batch_id = p_batch_id)
1134: AND b.shipping_method_code IS NOT NULL and
1135: NOT EXISTS (select LOOKUP_CODE
1136: FROM OE_SHIP_METHODS_V
1137: WHERE lookup_code = b.shipping_method_code
1138: AND SYSDATE <= NVL(END_DATE_ACTIVE, SYSDATE)) ;
1139:
1140: IF g_error_count = 0 THEN