pears.MasterTempRate

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