APPS.CS_KB_SOLN_IN_PROGRESS_PKG SQL Statements

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

Line: 15

  SELECT Soln.Set_id, Soln.Set_Number, Soln.Locked_By, Soln.FLow_Details_Id, Soln.Name,
         FlowDetail.Group_id
  FROM CS_KB_SETS_VL Soln,
       CS_KB_WF_FLOW_DETAILS FlowDetail
  WHERE Soln.STATUS IN ('SAV','NOT','REJ')
  AND   Soln.LATEST_VERSION_FLAG = 'Y'
  AND Soln.Flow_Details_id = FlowDetail.Flow_Details_Id (+)
  AND   Soln.Locked_BY > -1;

Line: 49

      UPDATE CS_KB_SETS_B
      SET Locked_By = -1,
          Lock_Date = NULL,
          Last_Update_Date = sysdate,
          Last_Updated_By = l_user,
          Last_Update_Login = l_login
      WHERE Set_Id = Solutions.Set_id;