Operation Details
Description: Method lists all the waiver associated with the given milestone delivery ID
Sterotype: nsmulti
SQL 
SELECT
  MilestoneWaiverApprovalRequest.waiverApprovalRequestID,
  MilestoneWaiverApprovalRequest.requestedDate,
  MilestoneWaiverApprovalRequest.requestedExpStartDate,
  MilestoneWaiverApprovalRequest.requestedExpEndDate,
  ApprovalRequest.status
INTO
  :waiverApprovalRequestID,
  :requestedDate,
  :requestedExpStartDate,
  :requestedExpEndDate,
  :approvalReqStatus 
FROM
  MilestoneWaiverApprovalRequest,
  ApprovalRequest 
WHERE MilestoneWaiverApprovalRequest.milestoneDeliveryID = :milestoneDeliveryID 
  AND MilestoneWaiverApprovalRequest.approvalRequestID = ApprovalRequest.approvalRequestID 
ORDER BY MilestoneWaiverApprovalRequest.requestedDate DESC