Operation Details
Description: Searches for trainings which are currently offered as services for a given training type.
Sterotype: nsmulti
SQL 
SELECT
  Training.trainingID,
  ServiceOffering.serviceOfferingID,
  Training.trainingName,
  Training.startDate,
  Training.endDate
INTO
  :trainingID,
  :serviceOfferingID,
  :trainingName,
  :trainingStartDate,
  :trainingEndDate 
FROM
  TrainingServiceOffering,
  ServiceOffering,
  Training 
WHERE Training.trainingType = :trainingType 
  AND TrainingServiceOffering.trainingID = Training.trainingID 
  AND TrainingServiceOffering.serviceOfferingID = ServiceOffering.serviceOfferingID 
  AND ServiceOffering.recordStatus = :recordStatus