Operation Details
Description: Method for reading authorized representative evidence and the participantRoleID of the authorized representative.
Sterotype: ns
SQL 
SELECT
  AuthorizedRep.evidenceID,
  AuthorizedRep.caseParticipantRoleID,
  AuthorizedRep.authorRepReason,
  AuthorizedRep.employeeOfDivInd,
  AuthorizedRep.mealsProviderForHLess,
  AuthorizedRep.authRetailerInd,
  AuthorizedRep.disqIPVInd,
  AuthorizedRep.comments,
  AuthorizedRep.versionNo,
  CaseParticipantRole.participantRoleID
INTO
  :evidenceID,
  :caseParticipantRoleID,
  :authorRepReason,
  :employeeOfDivInd,
  :mealsProviderForHLess,
  :authRetailerInd,
  :disqIPVInd,
  :comments,
  :versionNo,
  :participantRoleID 
FROM
  AuthorizedRep,
  CaseParticipantRole 
WHERE AuthorizedRep.evidenceID = :evidenceID 
  AND CaseParticipantRole.caseParticipantRoleID = AuthorizedRep.caseParticipantRoleID