pears.VacancyTempRate

CREATE FUNCTION "pears"."VacancyTempRate"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "VacID" CHAR(20),IN "BandID" CHAR(20),IN "GradeID" CHAR(4),IN "pFilter1" CHAR(4),IN "pFilter2" CHAR(4),IN "pFilter3" CHAR(4),IN "dFrom" DATE,IN "dTo" DATE ) 
RETURNS CHAR(20)
BEGIN
  DECLARE "rv" CHAR(20);
  SET "rv" = NULL;
  IF "trim"("isnull"("vacid",'')) <> '' THEN
    SELECT FIRST "r"."tempjobrateid" INTO "rv" FROM "tempjobrate" AS "r" WHERE "r"."vacancyid" = "vacid" AND "r"."temppaybandid" = "bandid"
      AND "trim"("isnull"("r"."grade",'')) = "trim"("isnull"("gradeid",''))
      AND "trim"("isnull"("r"."filter1",'')) = "trim"("isnull"("pFilter1",''))
      AND "trim"("isnull"("r"."filter2",'')) = "trim"("isnull"("pFilter2",''))
      AND "trim"("isnull"("r"."filter3",'')) = "trim"("isnull"("pFilter3",''))
      AND "isnull"("r"."startdate",'1900-01-01') <= "isnull"("dto",CURRENT DATE) AND "isnull"("r"."enddate",'2200-01-01') >= "isnull"("dfrom",CURRENT DATE)
  END IF;
  RETURN "rv"
END