Issue with Logic in PL/SQL code grouping data

   Hello Gurus

I have a requirement to send email to supervisors if Part Time employees reach a certain amount of hours in a calendar year. I will need to send notifications to supervisors, the sticking point is I need to send only one notice per manager. I have come up with PL/SQL procedure that gets me some what close, but I can't seem to find a way to break on the change in manager correctly. I'm using a FOR LOOP cursor and a variable for supervisor (V_SUPERVISOR) that I set to the supervisor in the cursor. If the variable is the same as