Operation Details
Description: Reads the concern role name, concern role id, home page name, member page name and type for an Integrated Case.
Sterotype: ns
SQL 
SELECT
  ConcernRole.concernRoleName,
  ConcernRole.concernRoleID,
  AdminIntegratedCase.homePageName,
  AdminIntegratedCase.memberHomePageName,
  AdminIntegratedCase.integratedCaseType
INTO
  :concernRoleName,
  :concernRoleID,
  :homePageName,
  :memberHomePageName,
  :integratedCaseType 
FROM
  CaseHeader CaseHeader1,
  ConcernRole,
  AdminIntegratedCase,
  CaseHeader CaseHeader2 
WHERE CaseHeader2.caseID = :caseID 
  AND 
  (
    CaseHeader1.caseID = :caseID 
    OR CaseHeader1.caseID = CaseHeader2.integratedCaseID 
  ) 
  AND ConcernRole.concernRoleID = CaseHeader1.concernRoleID 
  AND AdminIntegratedCase.integratedCaseType = CaseHeader1.integratedCaseType