Create a table called topay that has three fields: rec_no which is a varchar2(5), idno varchar2(5), amt number(6,2).
You will also get information from donor (actually a version of donor).
Take in an id number and then check the yrgoal on the record. If it is larger tahn 500, then double yrgoal to create the new goal. Otherwise, multiply by 1.5 to create the new goal. Take the newgoal and divide it by 4.
Now do a loop so that you write the record onto topay 4 times with different record numbers, but the same idno and amt. You handle the incrementing of the record number.