pears.VacancyTempRate [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.VacancyTempRate ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."VacancyTempRate" IS 
{create function 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
}
</code>