pears.MasterRosterStartDate

CREATE FUNCTION "pears"."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