Outer joining

[abhaysk]

try

from 
(Select ws.(Primary_Col_List),Emp.* from employee Emp, work_summary ws Where ws.emp_id=emp.emp_id(+)) e, 
pay_group pg, 
work_summary ws1,
work_summary ws2, 
work_summary ws3, 
work_summary ws4, 
work_summary ws5,
work_summary ws6
where 
nvl(e.emp_val1,#request.dbLocation#) = #request.dbLocation#
and nvl(e.emp_val1,pg.paygrp_name) = pg.paygrp_name
and ws1.emp_id = NVL(e.emp_id,ws1.emp_id) and e.(cols of ws)=ws1.(cols of pk)
and ws2.emp_id = NVL(e.emp_id,ws2.emp_id) and e.(cols of ws)=ws2.(cols of pk)
and ws3.emp_id = NVL(e.emp_id,ws3.emp_id) and e.(cols of ws)=ws3.(cols of pk)
and ws4.emp_id = NVL(e.emp_id,ws4.emp_id) and e.(cols of ws)=ws4.(cols of pk)
and ws5.emp_id = NVL(e.emp_id,ws5.emp_id) and e.(cols of ws)=ws5.(cols of pk)
and ws6.emp_id = NVL(e.emp_id,ws6.emp_id) and e.(cols of ws)=ws6.(cols of pk)
and pg.paygrp_end_date-42 = ws1.wrks_work_date
and pg.paygrp_end_date-35 = ws2.wrks_work_date
and pg.paygrp_end_date-28 = ws3.wrks_work_date
and pg.paygrp_end_date-21 = ws4.wrks_work_date
and pg.paygrp_end_date-14 = ws5.wrks_work_date
and pg.paygrp_end_date-7 = ws6.wrks_work_date

Abhay.