step 1. DELETE FROM all_vm_mint_prl_pay_summary_data WHERE PROC_MONTH=4 AND PROC_YEAR='2023';

step 2. 
INSERT INTO all_vm_mint_prl_pay_summary_data (ref_emp_id, PROC_MONTH, PROC_YEAR, TRN_CODE, GL_CODE, AMOUNT, Hours, TRN_NAME, SEQ, Narration, BOLD, ref_payroll_group_id)
  SELECT
    ref_emp_id,
    PROC_MONTH,
    PROC_YEAR,
    TRN_CODE,
    GL_CODE,
    AMOUNT,
    Hours,
    TRN_NAME,
    SEQ,
    Narration,
    BOLD,
    ref_payroll_group_id
  FROM VW_MINT_PRL_PAY_SUMMARY_TEST_02
  WHERE PROC_MONTH = '4'
  AND PROC_YEAR = '2023'   ;