Select Query Call Stack

[Madushanka Fonseka]

Hi.
I would like to know to execute a query like

select e.id,d.name from employees e, departments d
                where e.salary> 50000


what would be the  call stack and how byte codes get
connected/called/generated along with the help f resultset n execution
factories ?