DECLARE
  v_LBD varchar2(30):= (select max(run_date) from mousetrap.zrulunmatch_test@TO_MST);
BEGIN
update fdd.ul_instruments set ACTIVE = 'N', END_DT = null WHERE  feeder_source_system = 'INUL' and rowid in (
Select ROWID
---a.SEQ_NUM, a.MAX_SEQ_NUM, a.ACTIVE, a.inst_id, a.inst_src, a.ulinstid, a.ulinstsrc  
 from 
(
Select A1.*, MAX(SEQ_NUM) OVER (PARTITION BY INST_ID, INST_SRC, ULINSTID, ULINSTSRC ) max_seq_num FROM fdd.ul_instruments A1
              WHERE  feeder_source_system = 'INUL'
              and start_dt<=v_LBD AND NVL(END_DT,'99999999') >= v_LBD
)  a
WHERE a.SEQ_NUM=a.MAX_SEQ_NUM
                                AND ACTIVE='Y' 
and exists 
(
Select 1 from mousetrap.zrulunmatch_test@TO_MST b  where b.MMTCH_F ='UNMATCH_FDD' 
and b.FEEDER_SOURCE_SYSTEM = 'INUL' and b.run_date = v_LBD 
and a.inst_id = b.INST_ID and a.inst_src = b.inst_src and a.ulinstid = b.ulinstid and a.ulinstsrc =  b.ulinstsrc
) 
); 
COMMIT;   
END;

DECLARE
  v_LBD varchar2(30); 
BEGIN
  select max(run_date) into v_LBD from mousetrap.zrulunmatch_test@TO_MST;

update fdd.ul_instruments set ACTIVE = 'N', END_DT = null WHERE  feeder_source_system = 'INUL' and rowid in (
Select ROWID
---a.SEQ_NUM, a.MAX_SEQ_NUM, a.ACTIVE, a.inst_id, a.inst_src, a.ulinstid, a.ulinstsrc  
 from 
(
Select A1.*, MAX(SEQ_NUM) OVER (PARTITION BY INST_ID, INST_SRC, ULINSTID, ULINSTSRC ) max_seq_num FROM fdd.ul_instruments A1
              WHERE  feeder_source_system = 'INUL'
              and start_dt<=v_LBD AND NVL(END_DT,'99999999') >= v_LBD
)  a
WHERE a.SEQ_NUM=a.MAX_SEQ_NUM
                                AND ACTIVE='Y' 
and exists 
(
Select 1 from mousetrap.zrulunmatch_test@TO_MST b  where b.MMTCH_F ='UNMATCH_FDD' 
and b.FEEDER_SOURCE_SYSTEM = 'INUL' and b.run_date = v_LBD 
and a.inst_id = b.INST_ID and a.inst_src = b.inst_src and a.ulinstid = b.ulinstid and a.ulinstsrc =  b.ulinstsrc
) 
); 
COMMIT;   
END;