Operation Details
Description:  
Sterotype: nsmulti
SQL
SELECT
  TrainingProgramMember.trainingProgramID,
  partyConcernRoleID,
  unitsCompleted,
  unitsRequired,
  dateCompleted,
  waiverExpiryDate,
  trainingProgramMemberID,
  creditsAchieved,
  completion,
  status,
  TrainingProgramMember.versionNo
INTO
  :trainingProgramID,
  :partyConcernRoleID,
  :unitsCompleted,
  :unitsRequired,
  :dateCompleted,
  :waiverExpiryDate,
  :trainingProgramMemberID,
  :creditsAchieved,
  :completion,
  :status,
  :versionNo 
FROM
  TrainingProgramMember,
  TrainingProgram 
WHERE TrainingProgram.trainingID = :trainingID 
  AND TrainingProgramMember.partyConcernRoleID = :partyConcernRoleID 
  AND TrainingProgram.trainingProgramID = TrainingProgramMember.trainingProgramID