Operation Details
Description: Returns list of intake program application for a given intake application which will be processed at specified target system.
Sterotype: nsmulti
SQL 
SELECT 
      IntakeProgramApplication.intakeProgramApplicationID, IntakeProgramApplication.intakeApplicationID, IntakeProgramApplication.programTypeID, IntakeProgramApplication.status, IntakeProgramApplication.denialReason,       IntakeProgramApplication.enteredByUser, IntakeProgramApplication.disposedDateTime, IntakeProgramApplication.deadlineDate, IntakeProgramApplication.submittedDateTime, IntakeProgramApplication.versionNo 
INTO  
      :intakeProgramApplicationID, :intakeApplicationID, :programTypeID, :status, :denialReason, :enteredByUser, :disposedDateTime, :deadlineDate, :submittedDateTime, :versionNo 
FROM 
      IntakeProgramApplication 
INNER JOIN 
  	ProgramType ON ProgramType.programTypeID = IntakeProgramApplication.programTypeID 
INNER JOIN 
      RemoteSystem ON RemoteSystem.remoteSystemID = ProgramType. rmtSystemID AND RemoteSystem.targetSystemID=:targetSystemID 
WHERE 
	IntakeProgramApplication.intakeApplicationID=:intakeApplicationID