就这么小段:
INSERT INTO A_RCVED_PL_FLOW(RCVED_PL_ID,RCVED_AMT_ID,ITEM_CODE,PL_AMT,ORG_NO)
SELECT RCVED_PL_ID,RCVED_AMT_ID,ITEM_CODE,PL_AMT,ORG_NO
FROM A_RCVED_PL_FLOW@DB_EPM A
WHERE EXISTS (SELECT 1 FROM A_RCVED_FLOW B WHERE A.RCVED_AMT_ID=B.RCVED_AMT_ID AND B.ORG_NO LIKE V_SUB_DEPT)
AND A.ORG_NO LIKE V_SUB_DEPT;
COMMIT;