Database SQL Operation: CommunicationCVLink.searchByContractVersion
Description: | Searches for all the communication contract version link records related to a specific contract version. |
Sterotype: | nsmulti |
SELECT
CommunicationCVLink.communicationID,
CommunicationCVLink.contractVersionID
INTO
:communicationID,
:contractVersionID
FROM CommunicationCVLink, ConcernRoleCommunication
WHERE CommunicationCVLink.contractVersionID = :contractVersionID
AND CommunicationCVLink.communicationID = ConcernRoleCommunication.communicationID
AND ConcernRoleCommunication.documentTemplateID = :contractDocumentType
|