SELECT
  dc.outcomeplanID,
  dc.caseparticipantRoleID,
  min(dc.discrepancyRunDate),
  count (da.discrepancyID)
INTO
  :outcomePlanID,
  :caseParticipantRoleID,
  :discrepancyRunDate,
  :recordCount
FROM
  Discrepancy dc,
  Outcomeplan op, 
  DiscrepantActivity da
WHERE
  dc.outcomeplanid = op.outcomeplanid
  AND
  op.createdby = :userName
  AND
  da.discrepancyID = dc.discrepancyID
  AND
  da.resolutionStatus = :discrepantStatus 
GROUP BY dc.outcomeplanID,  dc.caseparticipantRoleID
ORDER BY dc.outcomeplanID