Database SQL Operation: EDApprovalRequest.searchApprovalRequestsByEvidenceDescriptorID
Description: | Returns a list of Approval Requests associated with this Evidence Descriptor |
Sterotype: | nsmulti |
SELECT
ApprovalRequest.approvalRequestID,
EDApprovalRequest.requestedDateTime,
Users.fullName,
ApprovalRequest.status
INTO
:approvalRequestID,
:requestedDateTime,
:requestedBy,
:status
FROM
ApprovalRequest,
EDApprovalRequest,
Users
WHERE EDApprovalRequest.evidenceDescriptorID = :evidenceDescriptorID
AND ApprovalRequest.approvalRequestID = EDApprovalRequest.approvalRequestID
AND ApprovalRequest.requestedByUser = Users.userName
|