405: , hr_all_organization_units org
406: , per_all_assignments_f asg
407: , per_jobs job
408: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
409: , hr_locations_all loc
410: --, per_employees_current_x emp
411: , per_all_people_f emp
412: -- WHERE NOT EXISTS (select source_id
413: WHERE NOT EXISTS (select 1
470: , hr_all_organization_units org
471: , per_all_assignments_f asg
472: , per_jobs job
473: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
474: , hr_locations_all loc
475: --, per_employees_current_x emp
476: , per_all_people_f emp
477: -- WHERE NOT EXISTS (select source_id
478: WHERE NOT EXISTS (select 1