====== 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>
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCanUploadVacancy" IS 
{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" v
where 
    "vacancyid" = "vacid" and 
    "status" = 'C'
 and
    ld >= current date) then
    return 1
  else return 0
  end if
end
}
</code>