pears.SDSRequired

CREATE FUNCTION "pears"."SDSRequired"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "COID" CHAR(20),IN "PID" CHAR(20) ) 
RETURNS SMALLINT
NOT deterministic
BEGIN
  IF "WPKMaintainGetSwitchValue"('IR35SDSON','','L') = 'N' THEN RETURN 0
  END IF;
  --  if exists (select 1 from company where PrivateSector = 1 and companyid = COID) then return 0 
  --  end if;
  IF EXISTS(SELECT 1 FROM "pay_employee" WHERE "personid" = "PID" AND "taxmethod" = 1) THEN RETURN 0
  END IF;
  IF EXISTS(SELECT 1 FROM "pay_employee" WHERE "personid" = "PID" AND "HMRCEngagementDetail" = 'F') THEN RETURN 0
  END IF;
  IF EXISTS(SELECT 1 FROM "companySDS" WHERE "personid" = "PID" AND "companyid" = "COID") THEN RETURN 0
  END IF;
  RETURN 1
END