Operation Details
Description: Searches for all the trainings that are listed as training requirement of any active provider offerings currently held by a provider group.
Sterotype: nsmulti
SQL 
SELECT
  Training.trainingID,
  ServiceOffering.serviceOfferingID,
  Training.trainingName,
  SOTrainingRequirement.completion,
  SOTrainingRequirement.soTrainingRequirementID,
  ServiceOffering.name
INTO
  :trainingID,
  :serviceOfferingID,
  :trainingName,
  :trainingRequirementCompletion,
  :trainingRequirementID,
  :serviceName 
FROM
  Training,
  SOTrainingRequirement,
  ProviderOffering,
  ServiceOffering,
  ProviderGroupAssociate 
WHERE Training.trainingID = SOTrainingRequirement.trainingID 
  AND SOTrainingRequirement.serviceOfferingID = ProviderOffering.serviceOfferingID 
  AND ProviderOffering.recordStatus <> :recordStatus 
  AND ProviderOffering.providerConcernRoleID = ProviderGroupAssociate.providerConcernRoleID 
  AND ProviderOffering.serviceOfferingID = ServiceOffering.serviceOfferingID 
  AND ProviderGroupAssociate.providerGroupConcernRoleID = :concernRoleID