pears.NetCanUploadVacancy

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
}