pears.MasterRosterStartDate

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."MasterRosterStartDate" IS 
{CREATE FUNCTION MasterRosterStartDate 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
( IN MRID CHAR(20),IN VacID CHAR(20) ) 
RETURNS CHAR(20)
BEGIN
  DECLARE MaxDays INTEGER;
  DECLARE SDate DATE;
  IF isnull(MRID,'') = '' THEN
    SELECT MAX(daysincycle) INTO MaxDays FROM Masterroster WHERE VacancyID = VacID;
    SELECT MIN(startdate) INTO SDate FROM Masterroster WHERE VacancyID = VacID AND daysincycle = MaxDays
  ELSE SELECT daysincycle,startdate INTO MaxDays,SDate FROM Masterroster WHERE MasterRosterID = MRID
  END IF;
  IF SDate <= CURRENT DATE THEN
    while CURRENT DATE NOT BETWEEN Sdate AND Sdate+MaxDays loop
      SET SDate = SDate+MaxDays
    END loop
  END IF;
  RETURN dateFormat(SDate,'yyyy-mm-dd')
END
}