Peoplesoft SQR randomly returns wrong values from Begin-SELECT.

Hi.

We have an SQR that retrieves Employee's Health Benefit Enrollments. Then for each employee, it calls a procedure that returns all enrolled dependents and employee. Parameters used to retrieve dependents are Employee ID and Effective Date. This program has been doing it's thing for a long time, until 2 weeks ago, when it starts dropping dependents.

Looking at our program logs, it shows that the effective date from the select statement returns the wrong date, randomly. It does not necessarily happen for the same employee each time. Occurrences of problems between excecutions can be from 0 to hundreds. The program was thoroughly reviewed and that there are no other sources of effective date value except from the SQL.