pears.IQXNetCompanyStartDate

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."IQXNetCompanyStartDate" IS 
{CREATE FUNCTION IQXNetCompanyStartDate 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN pCompanyID CHAR(20))
RETURNS DATE
BEGIN
  DECLARE nrv DOUBLE;
  SET nrv=NULL;
  SELECT FIRST VALUE INTO nrv FROM tagvalue WHERE taglocation = 'C' AND tagid = '9X0' AND id = pCompanyID;
  RETURN dateadd(DAY,isnull(nrv,0),'1899-12-30')
END
}