Database SQL Operation: ISPCaseDecisionSetProc.readAppDateAndEligibilityExModeByCaseDecisionID
Description: | Returns the application date and the eligibility execution mode fields for the provided case decision id. |
Sterotype: | ns |
SELECT
applicationDate,
eligibilityExecutionMode
INTO
:applicationDate,
:eligibilityExecutionMode
FROM
CaseDecisionSet,
ISPCaseDecisionSetProc
WHERE CaseDecisionSet.caseDecisionID = :caseDecisionID
AND CaseDecisionSet.instanceID = ISPCaseDecisionSetProc.caseDecisionSetInstanceID
|