Operation Details
Description: Reads all details about the planned item approval request record based on approval request id..
Sterotype: ns
SQL 
SELECT
  SPApprovalRequest.submitBaselineID,
  SPApprovalRequest.approvalBaselineID,
  BaselineSubmission.name,
  BaselineApproval.name
INTO
  :submissionBaselineID,
  :approvalBaselineID,
  :submissionBaselineName,
  :approvalBaselineName 
FROM
  SPApprovalRequest,
  Baseline BaselineSubmission,
  Baseline BaselineApproval 
WHERE SPApprovalRequest.approvalRequestID = :approvalRequestID 
  AND BaselineSubmission.baseLineID = SPApprovalRequest.submitBaselineID 
  AND BaselineApproval.baseLineID = SPApprovalRequest.approvalBaselineID