SQL:PAApprovalRequest.readApprovalRequestIDAndVersionNoByPlannedItemIDAndApprovalRequestStatus

Operation Details

Description:	Reads approvalRequestID and versionNo of the approval request record for a planned item with specified approval request status.
Sterotype:	ns

SQL

SELECT
  ApprovalRequest.approvalRequestID,
  ApprovalRequest.versionNo
INTO
  :approvalRequestID,
  :versionNo 
FROM
  PAApprovalRequest,
  ApprovalRequest 
WHERE PAApprovalRequest.plannedItemID = :plannedItemID 
  AND ApprovalRequest.approvalRequestID = PAApprovalRequest.approvalRequestID 
  AND ApprovalRequest.status = :status

Database SQL Operation: PAApprovalRequest.readApprovalRequestIDAndVersionNoByPlannedItemIDAndApprovalRequestStatus