Operation Details
Description: Read the default template type if a specific template does not exist for the product
Sterotype: ns
SQL 
SELECT
  organisationID,
  organisationTemplateID,
  productID,
  statusCode,
  templateID,
  templateName
INTO
  :organisationID,
  :organisationTemplateID,
  :productID,
  :statusCode,
  :templateID,
  :templateName 
FROM
  OrganisationTemplate 
WHERE 
  (
    productID IS NULL 
  ) 
  AND 
  (
    statusCode = :statusCode 
  ) 
  AND 
  (
    templateName = :templateName 
  )