SELECT
CaseNomineeObjective.caseNomineeObjectiveID,
CaseNomineeObjective.caseNomineeID,
CaseNomineeObjective.rulesObjectiveID,
CaseNomineeObjective.fromDate,
CaseNomineeObjective.toDate,
CaseNomineeObjective.statusCode
INTO
:caseNomineeObjectiveID,
:caseNomineeID,
:rulesObjectiveID,
:fromDate,
:toDate,
:statusCode
FROM
CaseNomineeObjective,
CaseNominee,
CaseParticipantRole
WHERE CaseParticipantRole.caseID = :caseID
AND CaseParticipantRole.caseParticipantRoleID = CaseNominee.caseParticipantRoleID
AND CaseNominee.caseNomineeID = CaseNomineeObjective.caseNomineeID
AND CaseNomineeObjective.rulesObjectiveID = :rulesObjectiveID
AND CaseNomineeObjective.statusCode = :statusCode
AND
(
CaseNomineeObjective.fromDate <= :toDate
AND
(
CaseNomineeObjective.toDate >= :fromDate
OR CaseNomineeObjective.toDate IS NULL
)
)
ORDER BY fromDate ASC
|