a few hours later, i discovered what that former programmer did. for that block, he/she used this:

Database
Query Data Source Type: FROM clause query
Query Data Source Name: (Select... /*in short, he/she used a VERY long query*/

I don't know if I had it right but through that single link that I found (since most of them are in different languages) it somewhat said that it is a stored procedure in a sense that it provided steps for me to follow. but then the steps can truly change the whole program and I don't know if it is really the best thing for me to do.

cmon guys...please help... i am so new to oracle yet the assignments I get are so advanced...