Operation Details
Description: Searches for all the trainings that are listed as training requirement of any license types currently held by a provider member.
Sterotype: nsmulti
SQL 
SELECT
  Training.trainingID,
  License.licenseID,
  LicenseTrainingRequirement.licenseTrainingRequirementID,
  Training.trainingName,
  LicenseTrainingRequirement.completion,
  LicenseTrainingRequirement.licenseType
INTO
  :trainingID,
  :licenseID,
  :trainingRequirementID,
  :trainingName,
  :trainingRequirementCompletion,
  :licenseType 
FROM
  Training,
  License,
  LicenseTrainingRequirement,
  ProviderParty 
WHERE Training.trainingID = LicenseTrainingRequirement.trainingID 
  AND LicenseTrainingRequirement.licenseType = License.licenseType 
  AND License.providerConcernRoleID = ProviderParty.providerConcernRoleID 
  AND ProviderParty.providerPartyID = :concernRoleID