pears.SDSRequired

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."SDSRequired" IS 
{CREATE FUNCTION 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
}