pears.NetOwnerCompanySalesStatuses

CREATE PROCEDURE "pears"."NetOwnerCompanySalesStatuses"( IN "pWebUserID" CHAR(20) ) 
RESULT( "CompanySalesStatusID" CHAR(1),"Name" CHAR(40),"SortOrder" INTEGER ) 
BEGIN
  SELECT "CompanySalesStatusID",
    "Name",
    "Sortorder"
    FROM "CompanySalesStatus"
    ORDER BY "SortOrder" ASC
END /* DOC
2020-06-01 GJ IW-1188 Created/Modified proc from Justin so it works on the web
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerCompanySalesStatuses" IS 
{CREATE PROCEDURE pears."NetOwnerCompanySalesStatuses"(IN pWebUserID CHAR(20))
RESULT (CompanySalesStatusID CHAR(1) ,[Name] CHAR(40) ,SortOrder INTEGER)
BEGIN
    SELECT
        CompanySalesStatusID,
        [Name],
        Sortorder
    FROM
        CompanySalesStatus
    ORDER BY
        SortOrder ASC
END
 
/* DOC
2020-06-01 GJ IW-1188 Created/Modified proc from Justin so it works on the web
*/
}