pears.NetCandidateCountUnacceptedShifts

CREATE PROCEDURE "pears"."NetCandidateCountUnacceptedShifts"( IN "pWebUserID" CHAR(20) ) 
RESULT( "ShiftCount" INTEGER ) 
BEGIN
  SELECT "count"()
    FROM "tempshift"
    WHERE "state" = 'P' AND "tempconfirmed" = 0 AND "personid" = any(SELECT "personid" FROM "iqxnetuserlink" WHERE "iqxnetuserid" = "pWebUserID") AND "shiftdate" >= CURRENT DATE
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateCountUnacceptedShifts" IS 
{CREATE PROCEDURE pears."NetCandidateCountUnacceptedShifts"(IN pWebUserID CHAR(20))
 RESULT( ShiftCount INTEGER ) 
BEGIN
SELECT 
   COUNT(*) 
FROM 
  tempshift
WHERE 
   state='P' AND tempconfirmed=0 AND personid IN (SELECT personid FROM iqxnetuserlink WHERE iqxnetuserid=pWebUserID) AND shiftdate >= CURRENT DATE;
END
}