Database SQL Operation: CaseNomineeObjective.searchCaseNomineeHistory
Description: | Returns all CaseNomineeObjective records over time on a Case, for a CaseNominee. |
Sterotype: | nsmulti |
SELECT
CaseNomineeObjective.rulesObjectiveID,
CaseNomineeObjective.fromDate,
CaseNomineeObjective.toDate,
CaseNomineeObjective.fromCaseStartDateInd
INTO
:rulesObjectiveID,
:fromDate,
:toDate,
:fromCaseStartDateInd
FROM
CaseNomineeObjective
WHERE CaseNomineeObjective.caseNomineeID = :caseNomineeID
AND CaseNomineeObjective.statusCode = :statusCode
|