SELECT
INTERNALASSISTANCEHISTORY.CASEPARTICIPANTROLEID,
INTERNALASSISTANCEHISTORY.NUMBEROFMONTHS,
INTERNALASSISTANCEHISTORY.STARTMONTH,
INTERNALASSISTANCEHISTORY.STARTYEAR,
INTERNALASSISTANCEHISTORY.ENDMONTH,
INTERNALASSISTANCEHISTORY.ENDYEAR
INTO
:caseParticipantRoleID,
:numberOfMonths,
:startMonth,
:startYear,
:endMonth,
:endYear
FROM
CASEHEADER,
INTERNALASSISTANCEHISTORY
WHERE CASEHEADER.INTEGRATEDCASEID = :caseID
AND CASEHEADER.CASEID = INTERNALASSISTANCEHISTORY.CASEID
AND INTERNALASSISTANCEHISTORY.PROGRAMTYPE = :programType
AND INTERNALASSISTANCEHISTORY.STATUS = 'RST1'
ORDER BY INTERNALASSISTANCEHISTORY.CASEPARTICIPANTROLEID
|