Operation Details
Description: Reads approval request status by planned item approval request key.
Sterotype: ns
SQL 
SELECT
  ApprovalRequest.status
INTO
  :status 
FROM
  PAApprovalRequest,
  ApprovalRequest 
WHERE PAApprovalRequest.plannedItemApprovalRequestID = :plannedItemApprovalRequestID 
  AND ApprovalRequest.approvalRequestID = PAApprovalRequest.approvalRequestID