SQL:SPApprovalRequest.readApprovalRequestIDAndVersionNoByCaseIDAndApprovalRequestStatus

Operation Details

Description:	Reads approvalRequestID and versionNo of the approval request record for a service plan delivery with specified approval request status.
Sterotype:	ns

SQL

SELECT
  ApprovalRequest.approvalRequestID,
  ApprovalRequest.versionNo
INTO
  :approvalRequestID,
  :versionNo 
FROM
  SPApprovalRequest,
  ApprovalRequest 
WHERE SPApprovalRequest.caseID = :caseID 
  AND ApprovalRequest.approvalRequestID = SPApprovalRequest.approvalRequestID 
  AND ApprovalRequest.status = :status

Database SQL Operation: SPApprovalRequest.readApprovalRequestIDAndVersionNoByCaseIDAndApprovalRequestStatus