Operation Details
Description: Retrieves a list of all services categories by locale and not associated with a specific service
Sterotype: nsmulti
SQL 
SELECT
  code
INTO
  :categoryCode 
FROM
  codetableitem 
WHERE tableName = :tablename 
 AND localeIdentifier= :localeCode
 AND isenabled = '1'
 AND code NOT in 
  ( 
  SELECT
    categoryCode 
  FROM
    ServiceCategory 
  WHERE serviceID = :serviceID 
  )