Mark,

Here's my solution that worked. Instead of:

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.

Amazing what a good night's sleep can do.

Thanks again for all the help.
Mike