Operation Details
Description: Reads all Products
Sterotype: nsmulti
SQL
SELECT
  productID,
  name,
  typeCode,
  statusCode,
  startDate,
  endDate,
  benefitInd,
  adminCategory,
  versionNo
INTO
  :productID,
  :name,
  :typeCode,
  :statusCode,
  :startDate,
  :endDate,
  :benefitInd,
  :adminCategory,
  :versionNo 
FROM
  Product
WHERE 
  (adminCategory = :adminCategory OR adminCategory IS NULL)
ORDER BY name