Operation Details
Description: Returns an ED Approval Request record using the Evidence Descriptor ID and current request indicator specified
Sterotype: ns
SQL 
SELECT
  EDApprovalRequest.edApprovalRequestID,
  EDApprovalRequest.approvalRequestID,
  EDApprovalRequest.currentRequestInd,
  EDApprovalRequest.evidenceDescriptorID,
  EDApprovalRequest.versionNo
INTO
  :edApprovalRequestID,
  :approvalRequestID,
  :currentRequestInd,
  :evidenceDescriptorID,
  :versionNo 
FROM
  EDApprovalRequest 
WHERE EDApprovalRequest.evidenceDescriptorID = :evidenceDescriptorID 
  AND EDApprovalRequest.currentRequestInd = :currentRequestInd