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