pears.MasterRosterTempAllowed

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."MasterRosterTempAllowed" IS 
{CREATE FUNCTION MasterRosterTempAllowed 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
( IN ppersid CHAR(20),IN pmastershiftid CHAR(20) ) 
RETURNS INTEGER
BEGIN
  DECLARE ionly INTEGER;
  DECLARE iactive INTEGER;
  IF pmastershiftid IS NULL THEN
    RETURN 1
  END IF;
  IF ppersid = (SELECT defaultpersonid FROM masterrostershift WHERE masterrostershiftid = pmastershiftid) THEN
    RETURN 1
  END IF;
  SELECT isnull(r.useonlypreferred,0),isnull(p.active,0) INTO ionly,iactive
    FROM masterrostershift AS s KEY JOIN masterroster AS r LEFT OUTER JOIN MasterRosterPreferredPerson AS p
      ON r.MasterRosterID = p.MasterRosterID AND p.PersonID = ppersid
    WHERE s.masterrostershiftid = pmastershiftid;
  IF ionly = 0 THEN
    RETURN 1
  ELSE
    RETURN iactive
  END IF
END
}