pears.TempContractTemplates

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE PROCEDURE "pears"."TempContractTemplates"( IN "ProgID" CHAR(20) ) 
RESULT( "templateid" CHAR(20) ) 
BEGIN
  -- result is used in IN clause
  SELECT "templateid" FROM "templatestore"
END