CREATE OR REPLACE PROCEDURE update_Last_Deal_Department
AS
v_mianinfoId zf_wf_transinfo.main_id%type;
v_orgId zf_wf_transinfo.unit_id%type;
v_i integer :=0;
v_j integer :=0;
v_k integer :=0;
CURSOR c_mian_info_all IS
SELECT zwm.id FROM zf_wf_maininfo zwm ;
CURSOR c_queryTransByMainId(mian_id VARCHAR2) IS
SELECT zft.unit_id FROM zf_wf_transinfo zft
WHERE zft.main_id=mian_id ORDER BY zft.tran_date DESC ;