pears.EmployeeAcceptable

CREATE FUNCTION "pears"."EmployeeAcceptable"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "persid" CHAR(20),IN "compid" CHAR(20),IN "iTemp" SMALLINT,IN "VacID" CHAR(20) DEFAULT NULL,IN "IncludeWithheld" SMALLINT DEFAULT 0 ) 
RETURNS CHAR(1)
BEGIN
  DECLARE "result" CHAR(1);
  SELECT IF "IncludeWithheld" <> 1 AND EXISTS(SELECT * FROM "withholds" WHERE "personid" = "persid" AND "companyid" = "compid") THEN 'W'
    ELSE IF "IncludeWithheld" <> 1 AND "VacID" IS NOT NULL AND EXISTS(SELECT * FROM "withholds" WHERE "VacancyID" = "VacID" AND "PersonID" = "persid") THEN 'V'
      ELSE IF "IncludeWithheld" <> 1 AND "VacID" IS NOT NULL AND EXISTS(SELECT * FROM "Person" WHERE "ExclusiveVacancyID" <> "VacID" AND "PersonID" = "persid") THEN 'X'
        ELSE IF "isnull"("itemp",0) <> 0 THEN NULL
          ELSE IF EXISTS(SELECT * FROM "employment" WHERE "personid" = "persid" AND "companyid" = "compid" AND "temp" = 0 AND "isnull"("leavedate",CURRENT DATE+10) > CURRENT DATE) THEN 'C'
            ELSE IF EXISTS(SELECT * FROM "employment" WHERE "personid" = "persid" AND "companyid" = "compid" AND "temp" = 0 AND "leavedate" > "dateadd"("year",-1,CURRENT DATE)) THEN 'R'
              ELSE NULL
              endif
            endif
          endif
        endif
      endif
    endif
    INTO "result";
  RETURN "result"
END