lcWhereString := ' AND (EMP.OUT_DT IS NULL OR EMP.OUT_DT >= pdCurrDate) ';I did this in stead:
lcWhereString := ' AND (EMP.OUT_DT IS NULL OR EMP.OUT_DT >= TO_DATE(''' || TO_CHAR(pdCurrDate, 'MM/DD/YYYY') || ''', ''MM/DD/YYYY'')) ';I guess the date variable didn't like being inside my string.