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
|