need an sql query to extract results in the attached format

[vijays 301989]

Hi Everyone,

I need a help in sql.

Below is the details:

from the front end, i will select few sql objects
for eg,
i am selecting
a) ProcedureName1, View_1 from Company_BAT and
b) GetEmpByProjID,GetAllProj, samplefunction from Company_DEV

here
ProcedureName1,GetEmpByProjID,GetAllProj are procedures.
View_1 is a view.
samplefunction is a function.

ProcedureName1 uses a) View_1 (View_1 uses Table_1)
b) Table_1
c) Table_2

View_1 uses a) Table_1

GetEmpByProjID uses a) Employee

GetAllProj uses a) Employee
b) Project

samplefunction a) it doesnt uses any objects

i need the output in the format as in the below screenshot in the below link:

http://vijays301989.blogspot.com/b/post-preview?token=QH4f3z8BAAA.jAJqT5poBN3LnJ\_eDbQDgA.vZNULScDlF40PLWlpXSZKA&postId=6529902930179783663&type=POST

PLease advise, how to obtain result in this format.