Operation Details
Description: Read ownership related sanctions list that make up each sanction member record.
Sterotype: nsmulti
SQL
SELECT
  ISPTRANSFERSANCTIONLINK.durationOfDisqualification,
  ISPTRANSFERSANCTIONLINK.disqualificationStartDate,
  ISPTRANSFERSANCTIONLINK.transferSanctionID,
  ISPTRANSFERSANCTIONLINK.linkedTransferType,
  ISPTRANSFERSANCTIONLINK.linkedID
INTO
  :durationOfDisqualification,
  :disqualificationStartDate,
  :transferSanctionID,
  :linkedTransferType,
  :linkedID 
FROM
  OWNERSHIP,
  ISPTRANSFERSANCTIONLINK,
  SANCTION 
WHERE OWNERSHIP.evidenceID = ISPTRANSFERSANCTIONLINK.linkedID 
  AND ISPTRANSFERSANCTIONLINK.sanctionID = :sanctionID