PROCEDURE excel IS
CURSOR C2(v_link_nm varchar2) is
select alt_loc LOC, alt_inv_no INV_NO, alt_inv_dt INV_DT, alt_amt AMOUNT, alt_rvc2 ALT_RVC,
alt_doc_no DOC_NO, alt_doc_typ DOC_TYP, alt_authid AUTH_ID, alt_authdt AUTH_DT
from v_link_nm
where alt_authdt between :FROM_DATE and :TO_DATE
MINUS
select a.alt_loc, a.alt_inv_no, a.alt_inv_dt, a.alt_amt, a.alt_rvc2,a.alt_doc_no, a.alt_doc_typ, a.alt_authid, a.alt_authdt from acc_loc1_tab a
where a.alt_authdt between :FROM_DATE and :TO_DATE
and a.alt_cmpny_cd = :GLOBAL.cmpny_cd ORDER BY 1,2,3;

begin

null;
end;