APPS.CSI_WEB_SERVICE_PKG SQL Statements

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

Line: 79

        SELECT  csi.instance_id
        INTO    l_instance_id
        FROM    csi_item_instances csi
        WHERE   csi.instance_id = p_instance_id
        AND     csi.instance_number = p_instance_number;

Line: 111

      SELECT  csi.instance_id
      INTO    l_instance_id
      FROM    csi_item_instances csi
      WHERE   csi.instance_number = p_instance_number;