BEGIN;
UPDATE  public.spHPY_Data_Inq_Rekap_Penghasilan_Kry_001 AS a
SET     a.totpenghasilankenapajak = b.bruto_pajak
FROM    hm_opy010 b
WHERE   a.byrtrxid = b.hm_msy012_bayar_prs_id AND
        a.byrtrxnumber = b.bayar_prs_number AND
        a.byrtrxdate = b.bayar_prs_date AND
        a.idkry = b.hm_oem001_karyawan_id AND
        a.thnblngaji = b.tahun_bulan_gaji