Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT
  ProviderType.providerCategoryID,
  ProviderType.providerTypeID,
  ProviderType.type,
  ProviderType.recordStatus,
  ProviderCategoryPeriod.category
INTO
  :providerCategoryID,
  :providerTypeID,
  :providerType,
  :recordStatus,
  :category 
FROM
  ProviderCategoryPeriod,
  ProviderType 
WHERE ProviderType.providerCategoryID =ProviderCategoryPeriod.providerCategoryID 
  AND ProviderType.type = :providerCategoryType 
  AND ProviderType.recordStatus = 'RST1'