Operation Details
Description: Reads the concernRoleID for the primary client on the case and the participantRoleID for the case nominee for which the caseNomineeID is provided.
Sterotype: ns
SQL 
SELECT
  CaseHeader.concernRoleID,
  CaseParticipantRole.participantRoleID
INTO
  :primaryClientConcernRoleID,
  :nomineeParticipantRoleID 
FROM
  CaseNominee,
  CaseParticipantRole,
  CaseHeader 
WHERE CaseNominee.caseNomineeID = :caseNomineeID 
  AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID 
  AND CaseHeader.caseID = CaseParticipantRole.caseID