====== pears.NetCanUploadVacancy ======
<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>
create function "pears"."NetCanUploadVacancy"( in "vacID" char(20) ) 
returns integer
begin
  if exists
    (select "Vacancyid",
      "isnull"((if "v"."temp" = 1 then "v"."finishdate" else "v"."expiry" endif),current date) as "LD"
      from "vacancy" as "v"
      where "vacancyid" = "vacid"
      and "status" = 'C'
      and "ld" >= current date) then
    return 1
  else return 0
  end if
end
</code>