Operation Details
Description: Returns Income Support Product Sanction Override Evidence details including the participant's full name.
Sterotype: ns
SQL 
SELECT
  SanctionOverride.sanctionOverrideID,
  SanctionOverride.concernRoleID,
  SanctionOverride.program,
  SanctionOverride.sanctionReason,
  SanctionOverride.startDate,
  SanctionOverride.endDate,
  SanctionOverride.comments,
  SanctionOverride.statusCode,
  SanctionOverride.versionNo,
  SanctionOverride.numberOfMonths,
  SanctionOverride.createdBy,
  SanctionOverride.createdOn,
  ConcernRole.concernRoleName,
  CaseHeader.caseID,
  CaseHeader.caseTypeCode,
  CaseHeader.caseReference	
INTO
  :sanctionOverrideID,
  :concernRoleID,
  :program,
  :sanctionReason,
  :startDate,
  :endDate,
  :comments,
  :statusCode,
  :versionNo,
  :numberOfMonths,
  :createdBy,
  :createdOn,
  :participantName,
  :caseID,
  :caseTypeCode,
  :caseReference	
FROM
  SanctionOverride,
  ConcernRole,
  CaseHeader 
WHERE SanctionOverride.sanctionOverrideID = :sanctionOverrideID 
  AND ConcernRole.concernRoleID = SanctionOverride.concernRoleID 
  AND CaseHeader.caseID = SanctionOverride.caseID