pears.VacancyAdjustRequirements

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE PROCEDURE "pears"."VacancyAdjustRequirements"( IN "vacID" CHAR(20) ) 
BEGIN
  IF EXISTS(SELECT "Vacancyid" FROM "vacancy" WHERE "vacancyid" = "vacid" AND "QuestionnaireUpdated" IS NOT NULL) THEN
    -- update requirements
    UPDATE "vacancy" SET "QuestionnaireUpdated" = NULL WHERE "vacancyid" = "vacid"
  END IF
END