Operation Details
Description: returns all the distinct product types belonging to a category
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT(Product.typeCode),
  Product.benefitInd
INTO
  :typeCode,
  :benefitInd 
FROM
  ProductCategory,
  Product,
  ProductConcernRole 
WHERE 
  (
    ProductCategory.categoryCode = :productCategoryCode 
    AND Product.statusCode = :statusCode 
    AND Product.startDate <= :searchDate 
    AND 
    (
      Product.endDate >= :searchDate 
      OR Product.endDate IS NULL 
    ) 
    AND Product.productID = ProductCategory.productID 
    AND ProductConcernRole.productID = Product.productID 
    AND ProductConcernRole.concernRoleType = :concernRoleType 
  )