SELECT CASEPARTICIPANTROLE.CASEPARTICIPANTROLEID,
CASEPARTICIPANTROLE.PARTICIPANTROLEID,
CASEPARTICIPANTROLE.CASEID,
CASEPARTICIPANTROLE.FROMDATE,
CASEPARTICIPANTROLE.TODATE,
CASEPARTICIPANTROLE.TYPECODE,
CASEPARTICIPANTROLE.RECORDSTATUS,
CASEPARTICIPANTROLE.ENDREASON,
CASEPARTICIPANTROLE.COMMENTS,
CASEPARTICIPANTROLE.TRANSLATIONREQUIREDIND
INTO :caseParticipantRoleID,
:participantRoleID,
:caseID,
:fromDate,
:toDate,
:typeCode,
:recordStatus,
:endReason,
:comments,
:translationRequiredInd
FROM CASEPARTICIPANTROLE WHERE
CASEPARTICIPANTROLE.CASEID=:caseID AND
CASEPARTICIPANTROLE.TYPECODE=:typeCode
|