Operation Details
Description: This method is used to retrieve the issueApprovalRequestID and associated approvalRequestID for a case
Sterotype: ns
SQL 
SELECT
  IssueApprovalRequest.issueApprovalRequestID,
  IssueApprovalRequest.approvalRequestID
INTO
  :issueApprovalRequestID,
  :approvalRequestID 
FROM
  IssueApprovalRequest,
  ApprovalRequest 
WHERE IssueApprovalRequest.caseID = :caseID 
  AND IssueApprovalRequest.approvalRequestID = ApprovalRequest.approvalRequestID 
  AND ApprovalRequest.approvalRequestID IN 
  ( 
  SELECT
    ApprovalRequest.approvalRequestID 
  FROM
    ApprovalRequest 
  WHERE ApprovalRequest.status = :approvalRequestStatus
  )