Operation Details
Description: To retrieve details from the caseHeader, concernRole and user entities, for display on the income screening case home page.
Sterotype: ns
SQL 
SELECT
  CaseHeader.registrationDate,
  CaseHeader.statusCode,
  CaseHeader.concernRoleID,
  CaseHeader.ownerOrgObjectLinkID,
  ConcernRole.concernRoleType,
  ConcernRole.concernRoleName
INTO
  :registrationDate,
  :recordStatus,
  :concernRoleID,
  :ownerOrgObjectLinkID,
  :concernRoleType,
  :concernRoleName 
FROM
  CaseHeader,
  ConcernRole 
WHERE CaseHeader.caseID = :caseID 
  AND ConcernRole.concernRoleID = CaseHeader.concernRoleID