Operation Details
Description: This method retrieves the current OPEN programWithdrawalRequest record for an application.
Sterotype: ns
SQL 
SELECT
  programWithdrawalRequestID,
  comments,
  denialReason,
  programApplicationID,
  requestedByConcernRoleID,
  requestMethod,
  resolvedDateTime,
  status,
  submittedDateTime,
  withDrawalOtherReason,
  withdrawalReason,
  versionNo
INTO
  :programWithdrawalRequestID,
  :comments,
  :denialReason,
  :programApplicationID,
  :requestedByConcernRoleID,
  :requestMethod,
  :resolvedDateTime,
  :status,
  :submittedDateTime,
  :withDrawalOtherReason,
  :withdrawalReason,
  :versionNo
  FROM
  ProgramWithdrawalRequest
WHERE 
ProgramWithdrawalRequest.programApplicationID = :programApplicationID 
AND ProgramWithdrawalRequest.status = :withdrawalRequestStatus;