test

select ds.flow_seq pk_serial, ds.dept_no,di.dept_name,si.emp_no,si.emp_name,bi.branch_code,bi.branch_name
       from rn_dept_servicer ds, staff_info si,department_info di, branch_info bi,branch_code_relation bcr
       where ds.service_no = si.emp_no
         and ds.is_valid = 'Y'
         and ds.dept_no = di.dept_no
         and di.branch_code = bi.branch_code
         and bcr.branch_code = bi.branch_code
         and bcr.relative_grade>-1
         and bcr.relative_branch_code = '8646'