pears.ValuesForAWRInvoiceFixedNIWTRLine

CREATE FUNCTION "pears"."ValuesForAWRInvoiceFixedNIWTRLine"( IN "tsid" CHAR(20),IN "tslineid" CHAR(20),IN "RecordType" CHAR(1) ) 
RETURNS DOUBLE
BEGIN
  -- RecordType W - WTR N - NI
  DECLARE "vid" CHAR(20);
  DECLARE "cid" CHAR(20);
  DECLARE "rv" DOUBLE;
  SET "rv" = 0;
  SELECT "companyid","vacancyid" INTO "cid","vid" FROM "employment" KEY JOIN "placement" KEY JOIN "temptimesheet" WHERE "temptimesheetid" = "tsid";
  CASE "RecordType"
  WHEN 'W' THEN //'Fixed WTR Rate. check vacancy, then company then non-awr' 
    SELECT "AWRFixedWTR" INTO "rv" FROM "vacancy" WHERE "vacancyid" = "vid";
    IF "isnull"("rv",0) <> 0 THEN RETURN "rv"
    END IF;
    SELECT "AWRFixedWTR" INTO "rv" FROM "companyaccount" WHERE "companyid" = "cid";
    IF "isnull"("rv",0) <> 0 THEN RETURN "rv"
    END IF;
    SELECT "FixedWTR" INTO "rv" FROM "companyaccount" WHERE "companyid" = "cid"
  WHEN 'N' THEN //'Fixed NI Rate.' 
    SELECT "AWRFixedNI" INTO "rv" FROM "vacancy" WHERE "vacancyid" = "vid";
    IF "isnull"("rv",0) <> 0 THEN RETURN "rv"
    END IF;
    SELECT "AWRFixedNI" INTO "rv" FROM "companyaccount" WHERE "companyid" = "cid";
    IF "isnull"("rv",0) <> 0 THEN RETURN "rv"
    END IF;
    SELECT "FixedNI" INTO "rv" FROM "companyaccount" WHERE "companyid" = "cid"
  END CASE;
  RETURN("rv")
END