Delete the duplicate data in oracle

Here the program ran twice and the data has been loaded twice. Now the below query removes the duplicates.

DELETE FROM XXUNV.XXUNV_FIS_AR_PAYMENTS_INT_ALL

WHERE rowid IN(

SELECT MAX(rowid)

FROM XXUNV.XXUNV_FIS_AR_PAYMENTS_INT_ALL

WHERE 1=1

  AND  TRUNC (creation_date) = TO_DATE ('20210821', 'YYYYMMDD')

  AND payment_id IN( 

 SELECT payment_id

 FROM XXUNV.XXUNV_FIS_AR_PAYMENTS_INT_ALL

WHERE 1=1

 AND TRUNC (creation_date) = TO_DATE ('20210821', 'YYYYMMDD')

  GROUP BY payment_id

  HAVING COUNT(*) > 1)

  GROUP BY payment_id);

  

COMMIT;

  

DELETE FROM XXUNV.XXUNV_FIS_AR_PAY_HIST_ALL

WHERE rowid IN(

SELECT MAX(rowid)

FROM XXUNV.XXUNV_FIS_AR_PAY_HIST_ALL

WHERE 1=1

  AND  TRUNC (creation_date) = TO_DATE ('20210821', 'YYYYMMDD')

  AND payment_id IN( 

 SELECT payment_id

 FROM XXUNV.XXUNV_FIS_AR_PAY_HIST_ALL

WHERE 1=1

 AND TRUNC (creation_date) = TO_DATE ('20210821', 'YYYYMMDD')

  GROUP BY payment_id

  HAVING COUNT(*) > 1)

  GROUP BY payment_id);

  

 COMMIT;