Operation Details
Description: Returns a list of standard program application details structs for the specified application and program application status.
Sterotype: nsmulti
SQL 
SELECT
  ProgramApplication.applicationID, ProgramApplication.deadlineDate, ProgramApplication.disposedDateTime,
  ProgramApplication.numWarningDays, ProgramApplication.programApplicationID,
  ProgramApplication.programApplicationStatusID, ProgramApplication.programRequestDate,
  ProgramApplication.programType, ProgramApplication.submittedDateTime,ProgramApplication.versionNo
INTO
  :applicationID,
  :deadlineDate,
  :disposedDateTime,
  :numWarningDays,
  :programApplicationID,
  :programApplicationStatusID,
  :programRequestDate,
  :programType,
  :submittedDateTime,
  :versionNo
FROM
   Application,
   ProgramApplication,
   ProgramApplicationStatus
WHERE application.applicationID = :applicationID
AND ProgramApplication.applicationID = application.applicationID
AND ProgramApplication.programType = :programType
AND ProgramApplication.programApplicationStatusID = ProgramApplicationStatus.programApplicationStatusID
AND ProgramApplicationStatus.status = :programStatus