pears.getcontactposition

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."getcontactposition" IS 
{CREATE FUNCTION 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
}