APPS.OE_BULK_WF_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 301

SELECT process_name
  FROM OE_WORKFLOW_ASSIGNMENTS
 WHERE order_type_id = p_type_id
   AND line_type_id IS NULL
   -- 11i10 - only fulfillment orders supported in HVOP so
   -- select fulfillment flow
   AND nvl(wf_item_type,'OEOH') = 'OEOH'
   AND sysdate >= start_date_active
   AND sysdate <= nvl(end_date_active, sysdate);

Line: 373

    SELECT process_name
          ,item_type_code
    FROM OE_WORKFLOW_ASSIGNMENTS
    WHERE order_type_id = p_order_type_id
      AND line_type_id = p_line_rec.line_type_id(p_line_index)
      AND nvl(item_type_code,l_wf_item_type) = l_wf_item_type
      AND sysdate >= start_date_active
      AND sysdate <= nvl(end_date_active, sysdate);