Database SQL Operation: IssueDelivery.readHomePageIDIssueTypeCaseRef
Description: | Reads the home page identifier, issue type and case reference for a Issue Delivery case. |
Sterotype: | ns |
SELECT
IssueConfiguration.homePageIdentifier,
IssueDelivery.issueType,
CaseHeader.caseReference
INTO
:homePageIdentifier,
:issueType,
:caseReference
FROM
IssueConfiguration,
IssueDelivery,
CaseHeader
WHERE IssueDelivery.caseID = :caseID
AND IssueConfiguration.issueConfigurationID = IssueDelivery.issueConfigurationID
AND CaseHeader.caseID = IssueDelivery.caseID
|