Operation Details
Description: returns a list of product types based on status, date, a benefit/liability indicator and concernRoleType.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT(Product.typeCode)
INTO
  :typeCode 
FROM
  Product,
  ProductConcernRole 
WHERE Product.benefitInd = :benefitInd 
  AND Product.statusCode = :statusCode 
  AND Product.startDate <= :searchDate 
  AND 
  (
    Product.endDate >= :searchDate 
    OR Product.endDate IS NULL 
  ) 
  AND ProductConcernRole.productID = Product.productID 
  AND ProductConcernRole.concernRoleType = :concernRoleType