SELECT
  dc.caseParticipantRoleID,
  dc.discrepancydate,
  dc.discrepancyRunDate,
  da.discrepantActivityID,
  da.activityid,
  da.activityType,
  da.activitystartdate,
  da.activityenddate,
  da.scheduleddurationinminutes,
  da.actualdurationinminutes,
  da.resolutionStatus,
  da.versionNo
INTO
  :caseParticipantRoleID,
  :discrepancyDate,
  :discrepancyRunDate,
  :discrepantActivityID,
  :activityID,
  :activityType,
  :activityStartDate,
  :activityEndDate,
  :scheduledDurationInMinutes,
  :actualDurationInMinutes,
  :resolutionStatus,
  :versionNo
FROM
  Discrepancy dc,
  DiscrepantActivity da
WHERE
  dc.outcomeplanid = :outcomePlanID
  AND
  da.discrepancyID = dc.discrepancyID
ORDER BY dc.caseParticipantRoleID