Operation Details
Description: Method to return a list of Client Types not eligible for a specified Product.
Sterotype: nsmulti
SQL
SELECT
  code
INTO
  :concernRoleType 
FROM
  codetableitem 
WHERE tableName = :tablename 
  AND code NOT in 
  ( 
  SELECT
    concernRoleType 
  FROM
    ProductConcernRole 
  WHERE productID = :productID 
  )