从ps_c_if_dept_tbl获取有效的部门有效部门查询条件:EFF_STATUS='A' and C_CRUD_FLAG !='D'
查找sql:心怡: select * from dept d where d.`ineffect_time`='9999-12-31' and d.`dept_type` = 0 and d.`dept_id` = 'ps_c_if_dept_tbl.DING_DEPTID去掉前缀' and dept_id not like 'GW_%'; 桔瓣: select * from dept_jb d where d.`ineffect_time`='9999-12-31' and d.`dept_id` = 'ps_c_if_dept_tbl.DING_DEPTID无需去前缀' ;
