SELECT
HouseholdMember.evidenceID,
HouseholdMember.caseParticipantRoleID,
ConcernRole.concernRoleName,
Person.dateOfBirth,
Person.maritalStatusCode,
HouseholdMember.veteranStatus,
HouseholdMember.migrantFWorkerInd,
HouseholdMember.ssnStatus,
ConcernRole.concernRoleID,
ConcernRole.primaryAlternateID
INTO
:evidenceID,
:caseParticipantRoleID,
:participantName,
:dateOfBirth,
:maritalStatusCode,
:veteranStatus,
:migrantFWorkerInd,
:ssnStatus,
:participantRoleID,
:alternateID
FROM
HouseholdMember,
CaseParticipantRole,
ConcernRole,
Person
WHERE HouseholdMember.evidenceID = :evidenceID
AND CaseParticipantRole.caseParticipantRoleID = HouseholdMember.caseParticipantRoleID
AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID
AND Person.concernRoleID = CaseParticipantRole.participantRoleID
|