Database SQL Operation: ISPTransferSanctionLink.readOwnershipRelatedTransferSanctionListDetails
Description: | Read ownership related sanctions list that make up each sanction member record. |
Sterotype: | nsmulti |
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
|