pears.MasterTempRate

CREATE FUNCTION "pears"."MasterTempRate"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "SchemeID" 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"("schemeid",'')) <> '' THEN
    SELECT FIRST "r"."tempjobratemasterid" INTO "rv" FROM "tempjobratemaster" AS "r" WHERE "r"."tempjobtypeid" = "schemeid" 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