sql

update GRAS_DEPT_SERVICER
         set
         SERVICER_NO=#{servicerNo,jdbcType=VARCHAR},
         UPDATED_USER = #{updatedUser,jdbcType=VARCHAR},
         UPDATED_DATE =sysdate
         where
         DEPT_NO =#{deptNo,jdbcType=VARCHAR}
         and  IS_VALID='Y'
         
         
         
         
         
          select  gbe.bank_code,di.dept_name,si.emp_no,si.emp_name,bi.branch_code,bi.branch_name,gbe.PK_SERIAL
     from GRAS_BANK_EMP gbe,
     staff_info si,
     department_info di,
      branch_info bi
     where
        gbe.emp_no=si.emp_no
        and si.dept_no=di.dept_no
       and di.branch_code=bi.branch_code 
       and gbe.END_DATE is null