Operation Details
Description: To retrieve any duplicate ad hoc bonus criteria records that may exist.
Sterotype: nsmulti
SQL 
SELECT
  adhocBonusCriteriaID,
  productID,
  bonusTypeCode,
  fromDate,
  toDate,
  bonusAmount,
  statusCode
INTO
  :adhocBonusCriteriaID,
  :productID,
  :bonusTypeCode,
  :fromDate,
  :toDate,
  :bonusAmount,
  :statusCode 
FROM
  AdhocBonusCriteria 
WHERE productID = :productID 
  AND bonusTypeCode = :bonusTypeCode 
  AND toDate >= :fromDate 
  AND fromDate <= :toDate