pears.EmployeeAcceptable

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