SELECT
	*
FROM
	dbo.Note_Terbit_Master
WHERE
  No_Ref = '2015.064520'

--UPDATE
--  ntm
--SET
--  Mata_Uang = pa.Mata_Uang,
--  --Status = 'G',
--  GT_OG = 'GT',  -- hardcode, sudah pasti GT
--  Sub_Init = pa.Sub_Init,
--  Tgl_Berlaku = pa.Tgl_Mulai
--FROM
--	dbo.gt_lapse_header AS glh INNER JOIN
--	dbo.Note_Terbit_Master AS ntm ON glh.no_ref = ntm.No_Ref INNER JOIN
--	dbo.Polis_Asuransi AS pa ON ntm.No_Proposal = pa.No_Proposal
--WHERE
--  glh.no_ref = '2015.064520'

--UPDATE
--	dbo.Note_Terbit_Master
--SET
--  Tgl_Buat = '2015-08-28',
--  No_Note = '064520/CN/GT/VIII/2015'
--WHERE
--  No_Ref = '2015.064520'

--UPDATE
--	dbo.Note_Terbit_Master
--SET
--  Tipe = -1
--WHERE
--  No_Ref = '2015.064520'
