====== pears.ValidatePayroll ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."ValidatePayroll" IS 
{create function pears."ValidatePayroll"                              (in recordid varchar(20),  in @BankName varchar(30),  in @BankAddr1 varchar(30),  in @BankAddr2 varchar(30),  in @BankSortCode varchar(8),  in @BankAcName varchar(50),  in @BankAcNo varchar(15),  in @BankRef varchar(20), in @PayMethod tinyint,  in @PayFrequency tinyint,  in @TaxMethod tinyint,  in @CompanyName varchar(50), in @RegNo varchar(20),  in @VATRegistered tinyint,  in @VATNumber varchar(20),  in @TaxCode varchar(5), in @NILetter varchar(1),  in @UniqueTaxReference varchar(20), in @Payrollnumber varchar(15), in @HMRCEngagementDetail char(1) )                                                                                           
returns long varchar
begin
  declare "RV" long varchar;
  declare "pcount" integer;
  if "isnull"(@payrollnumber,'') <> '' then
    select "count"() into "pcount" from "person" where "personid" <> "recordid" and "isnull"("payrollnumber",'') = @payrollnumber;
    if "pcount" > 0 then
      return('Payroll number already used')
    end if end if;
  return("RV")
end
}
</code>