Operation Details
Description: Returns an Approval Request record that is linked to an ED Approval request record using the Evidence Descriptor ID and current request indicator specified
Sterotype: ns
SQL 
SELECT
  ApprovalRequest.approvalRequestID,
  ApprovalRequest.versionNo,
  ApprovalRequest.requestedDate,
  ApprovalRequest.requestedByUser,
  ApprovalRequest.approvalDecisionDate,
  ApprovalRequest.approvalDecisionByUser,
  ApprovalRequest.documentRefNo,
  ApprovalRequest.approverTypeCode,
  ApprovalRequest.methodCode,
  ApprovalRequest.automaticallyApprovedInd,
  ApprovalRequest.status,
  ApprovalRequest.rejectionReason,
  ApprovalRequest.rejectionComments
INTO
  :approvalRequestID,
  :versionNo,
  :requestedDate,
  :requestedByUser,
  :approvalDecisionDate,
  :approvalDecisionByUser,
  :documentRefNo,
  :approverTypeCode,
  :methodCode,
  :automaticallyApprovedInd,
  :status,
  :rejectionReason,
  :rejectionComments 
FROM
  EDApprovalRequest,
  ApprovalRequest 
WHERE EDApprovalRequest.evidenceDescriptorID = :evidenceDescriptorID 
  AND EDApprovalRequest.currentRequestInd = :currentRequestInd 
  AND ApprovalRequest.approvalRequestID = EDApprovalRequest.approvalRequestID