SELECT
  tmp.*,
  pst.*
FROM
  [db_no_replicate_space].[dbo].[temp_prib_peserta_bbe_kmia] AS tmp LEFT JOIN
  GrpInsurance.dbo.Peserta AS pst ON tmp.Nama = pst.Nama
WHERE
  pst.No_Proposal = '2017.0004'


SELECT
  *
FROM
  [db_no_replicate_space].[dbo].[temp_prib_peserta_bbe_kmia] AS tmp INNER JOIN -- 69
  dbo.Peserta AS pst_lama ON tmp.Nopes = pst_lama.No_Peserta INNER JOIN
  dbo.Peserta AS pst_baru ON tmp.Nama = pst_baru.Nama
                             AND pst_lama.Tgl_Lahir = pst_baru.Tgl_Lahir
WHERE
  pst_lama.No_Proposal = '2016.0481'
  AND pst_baru.No_Proposal = '2017.0004'
---------------------------------------------
SELECT
	*
FROM
	dbo.Klaim_Peserta AS klaim INNER JOIN
	( SELECT
      pst_lama.No_Peserta AS No_Peserta_Lama,
      pst_baru.No_Peserta AS No_Peserta_Baru
    FROM
      [db_no_replicate_space].[dbo].[temp_prib_peserta_bbe_kmia] AS tmp INNER JOIN -- 69
      dbo.Peserta AS pst_lama ON tmp.Nopes = pst_lama.No_Peserta INNER JOIN
      dbo.Peserta AS pst_baru ON tmp.Nama = pst_baru.Nama
                                 AND pst_lama.Tgl_Lahir = pst_baru.Tgl_Lahir
    WHERE
      pst_lama.No_Proposal = '2016.0481'
      AND pst_baru.No_Proposal = '2017.0004'
	) AS pst ON klaim.No_Peserta = pst.No_Peserta_Lama
WHERE
  klaim.No_Proposal = '2016.0481'
ORDER BY
  klaim.No_Klaim
---------------------------------------------
SELECT
	*
FROM
	dbo.Klaim_Ref_Master
WHERE
  No_Klaim IN ( SELECT
	                klaim.No_Klaim
                FROM
	                dbo.Klaim_Peserta AS klaim INNER JOIN
	                ( SELECT
                      pst_lama.No_Peserta AS No_Peserta_Lama,
                      pst_baru.No_Peserta AS No_Peserta_Baru
                    FROM
                      [db_no_replicate_space].[dbo].[temp_prib_peserta_bbe_kmia] AS tmp INNER JOIN -- 69
                      dbo.Peserta AS pst_lama ON tmp.Nopes = pst_lama.No_Peserta INNER JOIN
                      dbo.Peserta AS pst_baru ON tmp.Nama = pst_baru.Nama
                                                 AND pst_lama.Tgl_Lahir = pst_baru.Tgl_Lahir
                    WHERE
                      pst_lama.No_Proposal = '2016.0481'
                      AND pst_baru.No_Proposal = '2017.0004'
	                ) AS pst ON klaim.No_Peserta = pst.No_Peserta_Lama
                WHERE
                  klaim.No_Proposal = '2016.0481')