Twisted and Confused!

This picture just about shows how I have been feeling lately! I have been really struggling with this function I am writing.

Without being boring, I need it to go off with a person id, grab all the current jobs for the employee, call another function to get the year to date gross pay balance for each job and then add them together.

It should be easy (or at least not terrible) but I am hopeless at doing Oracle PL/SQL loops and am making a mess of it.

I think this track will do the job....Don't Let Me Be Misunderstood