pears.getcontactposition

CREATE FUNCTION "pears"."getcontactposition"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "svacancyid" CHAR(20),IN "sprogressid" CHAR(20),IN "splacementid" CHAR(20) ) 
RETURNS CHAR(50)
BEGIN
  DECLARE "rv" CHAR(50);
  IF "svacancyid" IS NOT NULL THEN
    SELECT "position" INTO "rv" FROM "vacancy" WHERE "vacancyid" = "svacancyid";
    RETURN "rv"
  END IF;
  IF "sprogressid" IS NOT NULL THEN
    SELECT "vacancy"."position" INTO "rv" FROM "vacancy" KEY JOIN "progress"
      WHERE "progress"."progressid" = "sprogressid";
    RETURN "rv"
  END IF;
  IF "svacancyid" IS NOT NULL THEN
    SELECT "employment"."position" INTO "rv" FROM "employment" KEY JOIN "placement"
      WHERE "placement"."placementid" = "splacementid";
    RETURN "rv"
  END IF;
  RETURN ''
END