SELECT
  ApprovalRequest.approvalRequestID,
  EDApprovalRequest.requestedDateTime,
  ExternalUser.fullName,
  ApprovalRequest.status
INTO
  :approvalRequestID,
  :requestedDateTime,
  :requestedBy,
  :status 
FROM
  ApprovalRequest,
  EDApprovalRequest,
  ExternalUser 
WHERE EDApprovalRequest.evidenceDescriptorID = :evidenceDescriptorID 
  AND ApprovalRequest.approvalRequestID = EDApprovalRequest.approvalRequestID 
  AND ApprovalRequest.requestedByUser = ExternalUser.userName