|
Server IP : 127.0.0.1 / Your IP : 127.0.0.1 Web Server : Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3 System : Windows NT WIN-R7LTCC7BPLI 6.3 build 9200 (Windows Server 2012 R2 Datacenter Edition) i586 User : GerbangSIPAD ( 0) PHP Version : 5.6.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF Directory (0777) : C:/xampp5/htdocs/bhumie/upload/../report/CetakKeluaran/Pengurangan/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Keberatan_isi" language="groovy" pageWidth="612" pageHeight="1984" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="95937b38-e613-445c-84a0-33d2a77c4d3d">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="427"/>
<style name="table">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<subDataset name="dataset1" uuid="3a9b90a1-dbe8-48e7-b40f-71bb0d01824a">
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<queryString>
<![CDATA[select nm_kantor, al_kantor||', '||kota_terbit||', Telp. '||no_telpon||', Fax '||no_faksimili as alamat_kantor, kota_terbit from ref_kantor where kd_kanwil = $P{kd_kanwil} and kd_kantor = $P{kd_kantor}]]>
</queryString>
<field name="nm_kantor" class="java.lang.String"/>
<field name="alamat_kantor" class="java.lang.String"/>
<field name="kota_terbit" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset2" uuid="b6bcff25-073e-4f50-b18a-71409e05fe52">
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT A. NIP, A.NM_PEGAWAI FROM PEGAWAI A, POSISI_PEGAWAI B WHERE A.NIP = B.NIP
AND B.KD_KANWIL = $P{kd_kanwil}
AND B.KD_KANTOR = $P{kd_kantor}
AND B.KD_JABATAN = '10'
and b.KD_WEWENANG='10'
AND NOW() between b.TGL_AWAL_BERLAKU AND b.TGL_AKHIR_BERLAKU;]]>
</queryString>
<field name="nip" class="java.lang.String"/>
<field name="nm_pegawai" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset3" uuid="68cd9ba3-232f-48c8-8416-d30c4c26af77">
<queryString>
<![CDATA[select nm_ref from pbb.ref_umum where kd_ref=7]]>
</queryString>
<field name="nm_ref" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset4" uuid="6bd49733-e756-48c5-a151-482a0656db26">
<queryString>
<![CDATA[select nm_ref from pbb.ref_umum where kd_ref=8]]>
</queryString>
<field name="nm_ref" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset5" uuid="f12b0906-9a42-4c62-9d4b-a352a6a6b0c9">
<queryString>
<![CDATA[select nm_ref from pbb.ref_umum where kd_ref=9]]>
</queryString>
<field name="nm_ref" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset6" uuid="6d22c524-2610-4c01-b964-c305bb058b10">
<queryString>
<![CDATA[select nm_ref from pbb.ref_umum where kd_ref=10]]>
</queryString>
<field name="nm_ref" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset7" uuid="57fedc23-7d15-4cbd-9acc-2a9532fe3c29">
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<parameter name="thn_pelayanan" class="java.lang.String"/>
<parameter name="bundel_pelayanan" class="java.lang.String"/>
<parameter name="no_urut_pelayanan" class="java.lang.String"/>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<parameter name="kd_blok" class="java.lang.String"/>
<parameter name="no_urut" class="java.lang.String"/>
<parameter name="kd_jns_op" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT jns_pengurangan,
case
when jns_pengurangan='1'
then (
SELECT ltrim(rtrim(coalesce(B.temp_jalan_op,'')))||' '||ltrim(rtrim(coalesce(B.temp_blok_kav_no_op,'')))
FROM TEMP_DATA_OP B,PENGURANGAN_PERMANEN A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='2'
then (
SELECT ltrim(rtrim(coalesce(B.temp_jalan_op,'')))||' '||ltrim(rtrim(coalesce(B.temp_blok_kav_no_op,'')))
FROM TEMP_DATA_OP B,PENGURANGAN_PST A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='3'
then (
SELECT ltrim(rtrim(coalesce(B.temp_jalan_op,'')))||' '||ltrim(rtrim(coalesce(B.temp_blok_kav_no_op,'')))
FROM TEMP_DATA_OP B,PENGURANGAN_PENGENAAN_JPB A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='5'
then (
SELECT ltrim(rtrim(coalesce(C.jalan_op,'')))||' '||ltrim(rtrim(coalesce(c.blok_kav_no_op,'')))
FROM SPPT B,PENGURANGAN_PST A, DAT_OBJEK_PAJAK C,pst_detail d
WHERE ( B.kd_propinsi=A.kd_propinsi_pemohon
AND B.kd_dati2=A.kd_dati2_pemohon
AND B.kd_kecamatan=A.kd_kecamatan_pemohon
AND B.kd_kelurahan=A.kd_kelurahan_pemohon
AND B.kd_blok=A.kd_blok_pemohon
AND B.no_urut=A.no_urut_pemohon
AND B.kd_jns_op=A.kd_jns_op_pemohon
and B.thn_pajak_sppt=d.thn_pajak_permohonan)
and ( d.kd_kanwil = A.kd_kanwil
AND d.kd_KANTOR = A.kd_KANTOR
AND d.thn_pelayanan = A.thn_pelayanan
AND d.bundel_pelayanan = A.bundel_pelayanan
AND d.no_urut_pelayanan = A.no_urut_pelayanan
AND d.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND d.kd_dati2_pemohon=A.kd_dati2_pemohon
AND d.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND d.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND d.kd_blok_pemohon=A.kd_blok_pemohon
AND d.no_urut_pemohon=A.no_urut_pemohon
AND d.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (C.kd_propinsi=A.kd_propinsi_pemohon
AND C.kd_dati2=A.kd_dati2_pemohon
AND C.kd_kecamatan=A.kd_kecamatan_pemohon
AND C.kd_kelurahan=A.kd_kelurahan_pemohon
AND C.kd_blok=A.kd_blok_pemohon
AND C.no_urut=A.no_urut_pemohon
AND C.kd_jns_op=A.kd_jns_op_pemohon)
AND (A.kd_kanwil = $P{kd_kanwil}
AND A.kd_kantor = $P{kd_kantor}
AND A.thn_pelayanan = $P{thn_pelayanan}
AND A.bundel_pelayanan = $P{bundel_pelayanan}
AND A.no_urut_pelayanan = $P{no_urut_pelayanan}
AND A.kd_propinsi_pemohon = $P{kd_propinsi}
AND A.kd_dati2_pemohon = $P{kd_dati2}
AND A.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND A.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND A.kd_blok_pemohon = $P{kd_blok}
AND A.no_urut_pemohon = $P{no_urut}
AND A.kd_jns_op_pemohon = $P{kd_jns_op})
)
end as al_op
FROM pst_permohonan_pengurangan
WHERE
kd_kanwil= $P{kd_kanwil}
and kd_KANTOR= $P{kd_kantor}
and thn_pelayanan= $P{thn_pelayanan}
and bundel_pelayanan= $P{bundel_pelayanan}
and no_urut_pelayanan= $P{no_urut_pelayanan}
and kd_propinsi_pemohon= $P{kd_propinsi}
and kd_dati2_pemohon= $P{kd_dati2}
and kd_kecamatan_pemohon= $P{kd_kecamatan}
and kd_kelurahan_pemohon= $P{kd_kelurahan}
and kd_blok_pemohon= $P{kd_blok}
and no_urut_pemohon= $P{no_urut}
and kd_jns_op_pemohon= $P{kd_jns_op}]]>
</queryString>
<field name="jns_pengurangan" class="java.lang.String"/>
<field name="al_op" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset8" uuid="e175b4d3-22d0-4274-8eb8-02a41f471702">
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<parameter name="thn_pelayanan" class="java.lang.String"/>
<parameter name="bundel_pelayanan" class="java.lang.String"/>
<parameter name="no_urut_pelayanan" class="java.lang.String"/>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<parameter name="kd_blok" class="java.lang.String"/>
<parameter name="no_urut" class="java.lang.String"/>
<parameter name="kd_jns_op" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT jns_pengurangan,
case
when jns_pengurangan='1'
then (
SELECT coalesce(B.temp_rt_op,'')||'/'||coalesce(B.temp_rw_op,'')
FROM TEMP_DATA_OP B,PENGURANGAN_PERMANEN A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='2'
then (
SELECT coalesce(B.temp_rt_op,'')||'/'||coalesce(B.temp_rw_op,'')
FROM TEMP_DATA_OP B,PENGURANGAN_PST A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='3'
then (
SELECT coalesce(B.temp_rt_op,'')||'/'||coalesce(B.temp_rw_op,'')
FROM TEMP_DATA_OP B,PENGURANGAN_PENGENAAN_JPB A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='5'
then (
SELECT coalesce(C.rt_op,'')||'/'||coalesce(C.rw_op,'')
FROM SPPT B,PENGURANGAN_PST A, DAT_OBJEK_PAJAK C,pst_detail d
WHERE ( B.kd_propinsi=A.kd_propinsi_pemohon
AND B.kd_dati2=A.kd_dati2_pemohon
AND B.kd_kecamatan=A.kd_kecamatan_pemohon
AND B.kd_kelurahan=A.kd_kelurahan_pemohon
AND B.kd_blok=A.kd_blok_pemohon
AND B.no_urut=A.no_urut_pemohon
AND B.kd_jns_op=A.kd_jns_op_pemohon
and B.thn_pajak_sppt=d.thn_pajak_permohonan)
and ( d.kd_kanwil = A.kd_kanwil
AND d.kd_KANTOR = A.kd_KANTOR
AND d.thn_pelayanan = A.thn_pelayanan
AND d.bundel_pelayanan = A.bundel_pelayanan
AND d.no_urut_pelayanan = A.no_urut_pelayanan
AND d.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND d.kd_dati2_pemohon=A.kd_dati2_pemohon
AND d.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND d.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND d.kd_blok_pemohon=A.kd_blok_pemohon
AND d.no_urut_pemohon=A.no_urut_pemohon
AND d.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (C.kd_propinsi=A.kd_propinsi_pemohon
AND C.kd_dati2=A.kd_dati2_pemohon
AND C.kd_kecamatan=A.kd_kecamatan_pemohon
AND C.kd_kelurahan=A.kd_kelurahan_pemohon
AND C.kd_blok=A.kd_blok_pemohon
AND C.no_urut=A.no_urut_pemohon
AND C.kd_jns_op=A.kd_jns_op_pemohon)
AND (A.kd_kanwil = $P{kd_kanwil}
AND A.kd_kantor = $P{kd_kantor}
AND A.thn_pelayanan = $P{thn_pelayanan}
AND A.bundel_pelayanan = $P{bundel_pelayanan}
AND A.no_urut_pelayanan = $P{no_urut_pelayanan}
AND A.kd_propinsi_pemohon = $P{kd_propinsi}
AND A.kd_dati2_pemohon = $P{kd_dati2}
AND A.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND A.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND A.kd_blok_pemohon = $P{kd_blok}
AND A.no_urut_pemohon = $P{no_urut}
AND A.kd_jns_op_pemohon = $P{kd_jns_op})
)
end as rt_rw
FROM pst_permohonan_pengurangan
WHERE
kd_kanwil= $P{kd_kanwil}
and kd_KANTOR= $P{kd_kantor}
and thn_pelayanan= $P{thn_pelayanan}
and bundel_pelayanan= $P{bundel_pelayanan}
and no_urut_pelayanan= $P{no_urut_pelayanan}
and kd_propinsi_pemohon= $P{kd_propinsi}
and kd_dati2_pemohon= $P{kd_dati2}
and kd_kecamatan_pemohon= $P{kd_kecamatan}
and kd_kelurahan_pemohon= $P{kd_kelurahan}
and kd_blok_pemohon= $P{kd_blok}
and no_urut_pemohon= $P{no_urut}
and kd_jns_op_pemohon= $P{kd_jns_op}]]>
</queryString>
<field name="jns_pengurangan" class="java.lang.String"/>
<field name="rt_rw" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset9" uuid="a4452aa2-c4d3-4dd4-978d-a5f00e9805ca">
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<queryString>
<![CDATA[select nm_kelurahan from pbb.ref_kelurahan where
kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan = $P{kd_kecamatan}
and kd_kelurahan = $P{kd_kelurahan}]]>
</queryString>
<field name="nm_kelurahan" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset10" uuid="4131bf15-c589-4978-b2e5-13ffb69f0b3b">
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<queryString>
<![CDATA[select nm_kecamatan from pbb.ref_kecamatan where
kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan = $P{kd_kecamatan}]]>
</queryString>
<field name="nm_kecamatan" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset11" uuid="9864b01c-e7c8-4bf0-b342-a0b330902bc7">
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<queryString>
<![CDATA[select nm_dati2 from pbb.ref_dati2 where
kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}]]>
</queryString>
<field name="nm_dati2" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset12" uuid="5244b9b8-4b9f-4b4f-85ef-760bbe6050c8">
<parameter name="kd_propinsi" class="java.lang.String"/>
<queryString>
<![CDATA[select nm_propinsi from ref_propinsi where
kd_propinsi = $P{kd_propinsi}]]>
</queryString>
<field name="nm_propinsi" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset13" uuid="fe0b3341-c5f2-4a60-a1ea-4cc2282b49ec">
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<parameter name="thn_pelayanan" class="java.lang.String"/>
<parameter name="bundel_pelayanan" class="java.lang.String"/>
<parameter name="no_urut_pelayanan" class="java.lang.String"/>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<parameter name="kd_blok" class="java.lang.String"/>
<parameter name="no_urut" class="java.lang.String"/>
<parameter name="kd_jns_op" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT jns_pengurangan,pct_permohonan_pengurangan,
case
when jns_pengurangan='1'
then (
SELECT A.PCT_PENGURANGAN_PERMANEN
FROM TEMP_DATA_OP B,PENGURANGAN_PERMANEN A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='2'
then (
SELECT A.PCT_PENGURANGAN_PST
FROM TEMP_DATA_OP B,PENGURANGAN_PST A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='3'
then (
SELECT A.PCT_PENGURANGAN_JPB
FROM TEMP_DATA_OP B,PENGURANGAN_PENGENAAN_JPB A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='5'
then (
SELECT A.PCT_PENGURANGAN_PST
FROM SPPT B,PENGURANGAN_PST A, DAT_OBJEK_PAJAK C,pst_detail d
WHERE ( B.kd_propinsi=A.kd_propinsi_pemohon
AND B.kd_dati2=A.kd_dati2_pemohon
AND B.kd_kecamatan=A.kd_kecamatan_pemohon
AND B.kd_kelurahan=A.kd_kelurahan_pemohon
AND B.kd_blok=A.kd_blok_pemohon
AND B.no_urut=A.no_urut_pemohon
AND B.kd_jns_op=A.kd_jns_op_pemohon
and B.thn_pajak_sppt=d.thn_pajak_permohonan)
and ( d.kd_kanwil = A.kd_kanwil
AND d.kd_KANTOR = A.kd_KANTOR
AND d.thn_pelayanan = A.thn_pelayanan
AND d.bundel_pelayanan = A.bundel_pelayanan
AND d.no_urut_pelayanan = A.no_urut_pelayanan
AND d.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND d.kd_dati2_pemohon=A.kd_dati2_pemohon
AND d.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND d.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND d.kd_blok_pemohon=A.kd_blok_pemohon
AND d.no_urut_pemohon=A.no_urut_pemohon
AND d.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (C.kd_propinsi=A.kd_propinsi_pemohon
AND C.kd_dati2=A.kd_dati2_pemohon
AND C.kd_kecamatan=A.kd_kecamatan_pemohon
AND C.kd_kelurahan=A.kd_kelurahan_pemohon
AND C.kd_blok=A.kd_blok_pemohon
AND C.no_urut=A.no_urut_pemohon
AND C.kd_jns_op=A.kd_jns_op_pemohon)
AND (A.kd_kanwil = $P{kd_kanwil}
AND A.kd_kantor = $P{kd_kantor}
AND A.thn_pelayanan = $P{thn_pelayanan}
AND A.bundel_pelayanan = $P{bundel_pelayanan}
AND A.no_urut_pelayanan = $P{no_urut_pelayanan}
AND A.kd_propinsi_pemohon = $P{kd_propinsi}
AND A.kd_dati2_pemohon = $P{kd_dati2}
AND A.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND A.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND A.kd_blok_pemohon = $P{kd_blok}
AND A.no_urut_pemohon = $P{no_urut}
AND A.kd_jns_op_pemohon = $P{kd_jns_op})
)
end as vln_pengurang
FROM pst_permohonan_pengurangan
WHERE
kd_kanwil= $P{kd_kanwil}
and kd_KANTOR= $P{kd_kantor}
and thn_pelayanan= $P{thn_pelayanan}
and bundel_pelayanan= $P{bundel_pelayanan}
and no_urut_pelayanan= $P{no_urut_pelayanan}
and kd_propinsi_pemohon= $P{kd_propinsi}
and kd_dati2_pemohon= $P{kd_dati2}
and kd_kecamatan_pemohon= $P{kd_kecamatan}
and kd_kelurahan_pemohon= $P{kd_kelurahan}
and kd_blok_pemohon= $P{kd_blok}
and no_urut_pemohon= $P{no_urut}
and kd_jns_op_pemohon= $P{kd_jns_op}]]>
</queryString>
<field name="jns_pengurangan" class="java.lang.String"/>
<field name="pct_permohonan_pengurangan" class="java.lang.Float"/>
<field name="vln_pengurang" class="java.lang.Float"/>
<variable name="status" class="java.lang.String">
<variableExpression><![CDATA[($F{vln_pengurang}!=0 && $F{vln_pengurang}<$F{pct_permohonan_pengurangan}) ? "Mengabulkan sebagian " : (
($F{vln_pengurang} == $F{pct_permohonan_pengurangan}) ? "Mengabulkan seluruh " : (
($F{vln_pengurang}==0) ? "Menolak " : "Mengabulkan seluruh/sebagian/Menolak "
)
)]]></variableExpression>
</variable>
</subDataset>
<subDataset name="dataset14" uuid="ca6ab782-d9af-47ad-bb55-5327bdb17da1">
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<parameter name="thn_pelayanan" class="java.lang.String"/>
<parameter name="bundel_pelayanan" class="java.lang.String"/>
<parameter name="no_urut_pelayanan" class="java.lang.String"/>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<parameter name="kd_blok" class="java.lang.String"/>
<parameter name="no_urut" class="java.lang.String"/>
<parameter name="kd_jns_op" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT jns_pengurangan,
case
when jns_pengurangan='1'
then (
SELECT B.TEMP_PBB_YG_HARUS_DIBAYAR
FROM TEMP_DATA_OP B,PENGURANGAN_PERMANEN A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='2'
then (
SELECT B.TEMP_PBB_YG_HARUS_DIBAYAR
FROM TEMP_DATA_OP B,PENGURANGAN_PST A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='3'
then (
SELECT B.TEMP_PBB_YG_HARUS_DIBAYAR
FROM TEMP_DATA_OP B,PENGURANGAN_PENGENAAN_JPB A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='5'
then (
SELECT B.PBB_TERHUTANG_SPPT
FROM SPPT B,PENGURANGAN_PST A, DAT_OBJEK_PAJAK C,pst_detail d
WHERE ( B.kd_propinsi=A.kd_propinsi_pemohon
AND B.kd_dati2=A.kd_dati2_pemohon
AND B.kd_kecamatan=A.kd_kecamatan_pemohon
AND B.kd_kelurahan=A.kd_kelurahan_pemohon
AND B.kd_blok=A.kd_blok_pemohon
AND B.no_urut=A.no_urut_pemohon
AND B.kd_jns_op=A.kd_jns_op_pemohon
and B.thn_pajak_sppt=d.thn_pajak_permohonan)
and ( d.kd_kanwil = A.kd_kanwil
AND d.kd_KANTOR = A.kd_KANTOR
AND d.thn_pelayanan = A.thn_pelayanan
AND d.bundel_pelayanan = A.bundel_pelayanan
AND d.no_urut_pelayanan = A.no_urut_pelayanan
AND d.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND d.kd_dati2_pemohon=A.kd_dati2_pemohon
AND d.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND d.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND d.kd_blok_pemohon=A.kd_blok_pemohon
AND d.no_urut_pemohon=A.no_urut_pemohon
AND d.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (C.kd_propinsi=A.kd_propinsi_pemohon
AND C.kd_dati2=A.kd_dati2_pemohon
AND C.kd_kecamatan=A.kd_kecamatan_pemohon
AND C.kd_kelurahan=A.kd_kelurahan_pemohon
AND C.kd_blok=A.kd_blok_pemohon
AND C.no_urut=A.no_urut_pemohon
AND C.kd_jns_op=A.kd_jns_op_pemohon)
AND (A.kd_kanwil = $P{kd_kanwil}
AND A.kd_kantor = $P{kd_kantor}
AND A.thn_pelayanan = $P{thn_pelayanan}
AND A.bundel_pelayanan = $P{bundel_pelayanan}
AND A.no_urut_pelayanan = $P{no_urut_pelayanan}
AND A.kd_propinsi_pemohon = $P{kd_propinsi}
AND A.kd_dati2_pemohon = $P{kd_dati2}
AND A.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND A.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND A.kd_blok_pemohon = $P{kd_blok}
AND A.no_urut_pemohon = $P{no_urut}
AND A.kd_jns_op_pemohon = $P{kd_jns_op})
)
end as pbb_yg_harus_dibayar
FROM pst_permohonan_pengurangan
WHERE
kd_kanwil= $P{kd_kanwil}
and kd_KANTOR= $P{kd_kantor}
and thn_pelayanan= $P{thn_pelayanan}
and bundel_pelayanan= $P{bundel_pelayanan}
and no_urut_pelayanan= $P{no_urut_pelayanan}
and kd_propinsi_pemohon= $P{kd_propinsi}
and kd_dati2_pemohon= $P{kd_dati2}
and kd_kecamatan_pemohon= $P{kd_kecamatan}
and kd_kelurahan_pemohon= $P{kd_kelurahan}
and kd_blok_pemohon= $P{kd_blok}
and no_urut_pemohon= $P{no_urut}
and kd_jns_op_pemohon= $P{kd_jns_op}]]>
</queryString>
<field name="jns_pengurangan" class="java.lang.String"/>
<field name="pbb_yg_harus_dibayar" class="java.lang.Long"/>
</subDataset>
<subDataset name="dataset15" uuid="50d91215-9afb-44ad-9bf8-531ec72ddd55">
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<parameter name="thn_pelayanan" class="java.lang.String"/>
<parameter name="bundel_pelayanan" class="java.lang.String"/>
<parameter name="no_urut_pelayanan" class="java.lang.String"/>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<parameter name="kd_blok" class="java.lang.String"/>
<parameter name="no_urut" class="java.lang.String"/>
<parameter name="kd_jns_op" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT jns_pengurangan,
case
when jns_pengurangan='1'
then (
SELECT ROUND(B.TEMP_PBB_YG_HARUS_DIBAYAR*(A.PCT_PENGURANGAN_PERMANEN/100))
FROM TEMP_DATA_OP B,PENGURANGAN_PERMANEN A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='2'
then (
SELECT ROUND(B.TEMP_PBB_YG_HARUS_DIBAYAR*(A.PCT_PENGURANGAN_PST/100))
FROM TEMP_DATA_OP B,PENGURANGAN_PST A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='3'
then (
SELECT ROUND(B.TEMP_PBB_YG_HARUS_DIBAYAR*(A.PCT_PENGURANGAN_JPB/100))
FROM TEMP_DATA_OP B,PENGURANGAN_PENGENAAN_JPB A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='5'
then (
SELECT ROUND(B.PBB_TERHUTANG_SPPT*(A.PCT_PENGURANGAN_PST/100))
FROM SPPT B,PENGURANGAN_PST A, DAT_OBJEK_PAJAK C,pst_detail d
WHERE ( B.kd_propinsi=A.kd_propinsi_pemohon
AND B.kd_dati2=A.kd_dati2_pemohon
AND B.kd_kecamatan=A.kd_kecamatan_pemohon
AND B.kd_kelurahan=A.kd_kelurahan_pemohon
AND B.kd_blok=A.kd_blok_pemohon
AND B.no_urut=A.no_urut_pemohon
AND B.kd_jns_op=A.kd_jns_op_pemohon
and B.thn_pajak_sppt=d.thn_pajak_permohonan)
and ( d.kd_kanwil = A.kd_kanwil
AND d.kd_KANTOR = A.kd_KANTOR
AND d.thn_pelayanan = A.thn_pelayanan
AND d.bundel_pelayanan = A.bundel_pelayanan
AND d.no_urut_pelayanan = A.no_urut_pelayanan
AND d.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND d.kd_dati2_pemohon=A.kd_dati2_pemohon
AND d.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND d.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND d.kd_blok_pemohon=A.kd_blok_pemohon
AND d.no_urut_pemohon=A.no_urut_pemohon
AND d.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (C.kd_propinsi=A.kd_propinsi_pemohon
AND C.kd_dati2=A.kd_dati2_pemohon
AND C.kd_kecamatan=A.kd_kecamatan_pemohon
AND C.kd_kelurahan=A.kd_kelurahan_pemohon
AND C.kd_blok=A.kd_blok_pemohon
AND C.no_urut=A.no_urut_pemohon
AND C.kd_jns_op=A.kd_jns_op_pemohon)
AND (A.kd_kanwil = $P{kd_kanwil}
AND A.kd_kantor = $P{kd_kantor}
AND A.thn_pelayanan = $P{thn_pelayanan}
AND A.bundel_pelayanan = $P{bundel_pelayanan}
AND A.no_urut_pelayanan = $P{no_urut_pelayanan}
AND A.kd_propinsi_pemohon = $P{kd_propinsi}
AND A.kd_dati2_pemohon = $P{kd_dati2}
AND A.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND A.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND A.kd_blok_pemohon = $P{kd_blok}
AND A.no_urut_pemohon = $P{no_urut}
AND A.kd_jns_op_pemohon = $P{kd_jns_op})
)
end as pengurangan
FROM pst_permohonan_pengurangan
WHERE
kd_kanwil= $P{kd_kanwil}
and kd_KANTOR= $P{kd_kantor}
and thn_pelayanan= $P{thn_pelayanan}
and bundel_pelayanan= $P{bundel_pelayanan}
and no_urut_pelayanan= $P{no_urut_pelayanan}
and kd_propinsi_pemohon= $P{kd_propinsi}
and kd_dati2_pemohon= $P{kd_dati2}
and kd_kecamatan_pemohon= $P{kd_kecamatan}
and kd_kelurahan_pemohon= $P{kd_kelurahan}
and kd_blok_pemohon= $P{kd_blok}
and no_urut_pemohon= $P{no_urut}
and kd_jns_op_pemohon= $P{kd_jns_op}]]>
</queryString>
<field name="jns_pengurangan" class="java.lang.String"/>
<field name="pengurangan" class="java.lang.Double"/>
</subDataset>
<subDataset name="dataset16" uuid="edf9a82b-9486-4016-a4db-85975215f5ea">
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<parameter name="thn_pelayanan" class="java.lang.String"/>
<parameter name="bundel_pelayanan" class="java.lang.String"/>
<parameter name="no_urut_pelayanan" class="java.lang.String"/>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<parameter name="kd_blok" class="java.lang.String"/>
<parameter name="no_urut" class="java.lang.String"/>
<parameter name="kd_jns_op" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT jns_pengurangan,
case
when jns_pengurangan='1'
then (
SELECT (B.TEMP_PBB_YG_HARUS_DIBAYAR-(ROUND(B.TEMP_PBB_YG_HARUS_DIBAYAR*(A.PCT_PENGURANGAN_PERMANEN/100))))
FROM TEMP_DATA_OP B,PENGURANGAN_PERMANEN A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='2'
then (
SELECT (B.TEMP_PBB_YG_HARUS_DIBAYAR-(ROUND(B.TEMP_PBB_YG_HARUS_DIBAYAR*(A.PCT_PENGURANGAN_PST/100))))
FROM TEMP_DATA_OP B,PENGURANGAN_PST A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='3'
then (
SELECT (B.TEMP_PBB_YG_HARUS_DIBAYAR-(ROUND(B.TEMP_PBB_YG_HARUS_DIBAYAR*(A.PCT_PENGURANGAN_JPB/100))))
FROM TEMP_DATA_OP B,PENGURANGAN_PENGENAAN_JPB A
WHERE ( B.kd_kanwil = A.kd_kanwil
AND B.kd_KANTOR = A.kd_KANTOR
AND B.thn_pelayanan = A.thn_pelayanan
AND B.bundel_pelayanan = A.bundel_pelayanan
AND B.no_urut_pelayanan = A.no_urut_pelayanan
AND B.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND B.kd_dati2_pemohon=A.kd_dati2_pemohon
AND B.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND B.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND B.kd_blok_pemohon=A.kd_blok_pemohon
AND B.no_urut_pemohon=A.no_urut_pemohon
AND B.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (B.kd_kanwil = $P{kd_kanwil}
AND B.kd_kantor = $P{kd_kantor}
AND B.thn_pelayanan = $P{thn_pelayanan}
AND B.bundel_pelayanan = $P{bundel_pelayanan}
AND B.no_urut_pelayanan = $P{no_urut_pelayanan}
AND B.kd_propinsi_pemohon = $P{kd_propinsi}
AND B.kd_dati2_pemohon = $P{kd_dati2}
AND B.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND B.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND B.kd_blok_pemohon = $P{kd_blok}
AND B.no_urut_pemohon = $P{no_urut}
AND B.kd_jns_op_pemohon = $P{kd_jns_op})
)
when jns_pengurangan='5'
then (
SELECT (B.PBB_TERHUTANG_SPPT-ROUND(B.PBB_TERHUTANG_SPPT*(A.PCT_PENGURANGAN_PST/100)))
FROM SPPT B,PENGURANGAN_PST A, DAT_OBJEK_PAJAK C,pst_detail d
WHERE ( B.kd_propinsi=A.kd_propinsi_pemohon
AND B.kd_dati2=A.kd_dati2_pemohon
AND B.kd_kecamatan=A.kd_kecamatan_pemohon
AND B.kd_kelurahan=A.kd_kelurahan_pemohon
AND B.kd_blok=A.kd_blok_pemohon
AND B.no_urut=A.no_urut_pemohon
AND B.kd_jns_op=A.kd_jns_op_pemohon
and B.thn_pajak_sppt=d.thn_pajak_permohonan)
and ( d.kd_kanwil = A.kd_kanwil
AND d.kd_KANTOR = A.kd_KANTOR
AND d.thn_pelayanan = A.thn_pelayanan
AND d.bundel_pelayanan = A.bundel_pelayanan
AND d.no_urut_pelayanan = A.no_urut_pelayanan
AND d.kd_propinsi_pemohon=A.kd_propinsi_pemohon
AND d.kd_dati2_pemohon=A.kd_dati2_pemohon
AND d.kd_kecamatan_pemohon=A.kd_kecamatan_pemohon
AND d.kd_kelurahan_pemohon=A.kd_kelurahan_pemohon
AND d.kd_blok_pemohon=A.kd_blok_pemohon
AND d.no_urut_pemohon=A.no_urut_pemohon
AND d.kd_jns_op_pemohon=A.kd_jns_op_pemohon)
AND (C.kd_propinsi=A.kd_propinsi_pemohon
AND C.kd_dati2=A.kd_dati2_pemohon
AND C.kd_kecamatan=A.kd_kecamatan_pemohon
AND C.kd_kelurahan=A.kd_kelurahan_pemohon
AND C.kd_blok=A.kd_blok_pemohon
AND C.no_urut=A.no_urut_pemohon
AND C.kd_jns_op=A.kd_jns_op_pemohon)
AND (A.kd_kanwil = $P{kd_kanwil}
AND A.kd_kantor = $P{kd_kantor}
AND A.thn_pelayanan = $P{thn_pelayanan}
AND A.bundel_pelayanan = $P{bundel_pelayanan}
AND A.no_urut_pelayanan = $P{no_urut_pelayanan}
AND A.kd_propinsi_pemohon = $P{kd_propinsi}
AND A.kd_dati2_pemohon = $P{kd_dati2}
AND A.kd_kecamatan_pemohon = $P{kd_kecamatan}
AND A.kd_kelurahan_pemohon = $P{kd_kelurahan}
AND A.kd_blok_pemohon = $P{kd_blok}
AND A.no_urut_pemohon = $P{no_urut}
AND A.kd_jns_op_pemohon = $P{kd_jns_op})
)
end as pbb_setelah_terhutang
FROM pst_permohonan_pengurangan
WHERE
kd_kanwil= $P{kd_kanwil}
and kd_KANTOR= $P{kd_kantor}
and thn_pelayanan= $P{thn_pelayanan}
and bundel_pelayanan= $P{bundel_pelayanan}
and no_urut_pelayanan= $P{no_urut_pelayanan}
and kd_propinsi_pemohon= $P{kd_propinsi}
and kd_dati2_pemohon= $P{kd_dati2}
and kd_kecamatan_pemohon= $P{kd_kecamatan}
and kd_kelurahan_pemohon= $P{kd_kelurahan}
and kd_blok_pemohon= $P{kd_blok}
and no_urut_pemohon= $P{no_urut}
and kd_jns_op_pemohon= $P{kd_jns_op}]]>
</queryString>
<field name="jns_pengurangan" class="java.lang.String"/>
<field name="pbb_setelah_terhutang" class="java.lang.Double"/>
</subDataset>
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_kantor" class="java.lang.String"/>
<parameter name="thn_pelayanan_awal" class="java.lang.String"/>
<parameter name="bundel_pelayanan_awal" class="java.lang.String"/>
<parameter name="no_urut_pelayanan_awal" class="java.lang.String"/>
<parameter name="kd_propinsi_awal" class="java.lang.String"/>
<parameter name="kd_dati2_awal" class="java.lang.String"/>
<parameter name="kd_kecamatan_awal" class="java.lang.String"/>
<parameter name="kd_kelurahan_awal" class="java.lang.String"/>
<parameter name="kd_blok_awal" class="java.lang.String"/>
<parameter name="no_urut_awal" class="java.lang.String"/>
<parameter name="kd_jns_op_awal" class="java.lang.String"/>
<parameter name="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pelayanan_akhir" class="java.lang.String"/>
<parameter name="bundel_pelayanan_akhir" class="java.lang.String"/>
<parameter name="no_urut_pelayanan_akhir" class="java.lang.String"/>
<parameter name="kd_propinsi_akhir" class="java.lang.String"/>
<parameter name="kd_dati2_akhir" class="java.lang.String"/>
<parameter name="kd_kecamatan_akhir" class="java.lang.String"/>
<parameter name="kd_kelurahan_akhir" class="java.lang.String"/>
<parameter name="kd_blok_akhir" class="java.lang.String"/>
<parameter name="no_urut_akhir" class="java.lang.String"/>
<parameter name="kd_jns_op_akhir" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT * FROM (SELECT A.STATUS_KOLEKTIF, ltrim(rtrim(A.NO_SRT_PERMOHONAN)) as NO_SRT_PERMOHONAN ,
A.TGL_SURAT_PERMOHONAN, A.TGL_TERIMA_DOKUMEN_WP, B.KD_JNS_PELAYANAN, B.THN_PAJAK_PERMOHONAN,
C.KD_KANWIL, C.KD_KANTOR, C.THN_PELAYANAN, C.BUNDEL_PELAYANAN, C.NO_URUT_PELAYANAN, C.KD_PROPINSI_PEMOHON,
C.KD_DATI2_PEMOHON, C.KD_KECAMATAN_PEMOHON, C.KD_KELURAHAN_PEMOHON, C.KD_BLOK_PEMOHON, C.NO_URUT_PEMOHON,
C.KD_JNS_OP_PEMOHON, C.JNS_PENGURANGAN,
SK.JNS_SK, SK.NO_SK, SK.TGL_SK, SK.NO_BA_KANTOR, SK.TGL_BA_KANTOR,SK.NO_BA_LAPANGAN, SK.TGL_BA_LAPANGAN,
SK2.JNS_SK as jns_sk1, SK2.NO_SK as no_sk1, SK2.TGL_SK as tgl_sk1, SK2.NO_BA_KANTOR as no_ba_kantor1, SK2.TGL_BA_KANTOR as tgl_ba_kantor1,SK2.NO_BA_LAPANGAN as no_ba_lapangan1, SK2.TGL_BA_LAPANGAN as tgl_ba_lapangan1,
SK3.JNS_SK as jns_sk2, SK3.NO_SK as no_sk2, SK3.TGL_SK as tgl_sk2, SK3.NO_BA_KANTOR as no_ba_kantor2, SK3.TGL_BA_KANTOR as tgl_ba_kantor2,SK3.NO_BA_LAPANGAN as no_ba_lapangan2, SK3.TGL_BA_LAPANGAN as tgl_ba_lapangan2
FROM PST_PERMOHONAN A, PST_DETAIL B, PST_PERMOHONAN_PENGURANGAN C,
SK_SK SK, PENGURANGAN_PERMANEN PERMANEN,
SK_SK SK2, PENGURANGAN_PST PENGURANGAN,
SK_SK SK3, PENGURANGAN_PENGENAAN_JPB PENGURANGAN_JPB
WHERE ((B.NO_URUT_PELAYANAN = A.NO_URUT_PELAYANAN
AND B.BUNDEL_PELAYANAN = A.BUNDEL_PELAYANAN
AND B.THN_PELAYANAN = A.THN_PELAYANAN
AND B.KD_KANTOR = A.KD_KANTOR
AND B.KD_KANWIL = A.KD_KANWIL
and B.kd_jns_pelayanan='08'
and A.status_kolektif='0')
AND (C.KD_KANWIL = B.KD_KANWIL)
AND (C.KD_KANTOR = B.KD_KANTOR)
AND (C.THN_PELAYANAN = B.THN_PELAYANAN)
AND (C.BUNDEL_PELAYANAN = B.BUNDEL_PELAYANAN)
AND (C.NO_URUT_PELAYANAN = B.NO_URUT_PELAYANAN)
AND (C.KD_PROPINSI_PEMOHON = B.KD_PROPINSI_PEMOHON)
AND (C.KD_DATI2_PEMOHON = B.KD_DATI2_PEMOHON)
AND (C.KD_KECAMATAN_PEMOHON = B.KD_KECAMATAN_PEMOHON)
AND (C.KD_KELURAHAN_PEMOHON = B.KD_KELURAHAN_PEMOHON)
AND (C.KD_BLOK_PEMOHON = B.KD_BLOK_PEMOHON)
AND (C.NO_URUT_PEMOHON = B.NO_URUT_PEMOHON)
AND (C.KD_JNS_OP_PEMOHON = B.KD_JNS_OP_PEMOHON)
and (C.jns_pengurangan in ('1','2','3','5'))
and
(PERMANEN.NO_SK=SK.NO_SK
AND PERMANEN.JNS_SK=SK.JNS_SK
AND PERMANEN.KD_KANTOR=SK.KD_KANTOR
AND PERMANEN.KD_KANWIL=SK.KD_KANWIL)
AND
(PENGURANGAN.NO_SK=SK2.NO_SK
AND PENGURANGAN.JNS_SK=SK2.JNS_SK
AND PENGURANGAN.KD_KANTOR=SK2.KD_KANTOR
AND PENGURANGAN.KD_KANWIL=SK2.KD_KANWIL)
AND
(PENGURANGAN_JPB.NO_SK=SK3.NO_SK
AND PENGURANGAN_JPB.JNS_SK=SK3.JNS_SK
AND PENGURANGAN_JPB.KD_KANTOR=SK3.KD_KANTOR
AND PENGURANGAN_JPB.KD_KANWIL=SK3.KD_KANWIL)
)
union
SELECT ALL A.STATUS_KOLEKTIF,
A.NO_SRT_PERMOHONAN,
A.TGL_SURAT_PERMOHONAN,
A.TGL_TERIMA_DOKUMEN_WP,
B.KD_JNS_PELAYANAN, B.THN_PAJAK_PERMOHONAN, C.KD_KANWIL, C.KD_KANTOR, C.THN_PELAYANAN, C.BUNDEL_PELAYANAN, C.NO_URUT_PELAYANAN, C.KD_PROPINSI_PEMOHON, C.KD_DATI2_PEMOHON, C.KD_KECAMATAN_PEMOHON, C.KD_KELURAHAN_PEMOHON, C.KD_BLOK_PEMOHON, C.NO_URUT_PEMOHON, C.KD_JNS_OP_PEMOHON,
C.JNS_PENGURANGAN,
SK.JNS_SK, SK.NO_SK, SK.TGL_SK, SK.NO_BA_KANTOR, SK.TGL_BA_KANTOR,SK.NO_BA_LAPANGAN, SK.TGL_BA_LAPANGAN,
SK2.JNS_SK as jns_sk1, SK2.NO_SK as no_sk1, SK2.TGL_SK as tgl_sk1, SK2.NO_BA_KANTOR as no_ba_kantor1, SK2.TGL_BA_KANTOR as tgl_ba_kantor1,SK2.NO_BA_LAPANGAN as no_ba_lapangan1, SK2.TGL_BA_LAPANGAN as tgl_ba_lapangan1,
SK3.JNS_SK as jns_sk2, SK3.NO_SK as no_sk2, SK3.TGL_SK as tgl_sk2, SK3.NO_BA_KANTOR as no_ba_kantor2, SK3.TGL_BA_KANTOR as tgl_ba_kantor2,SK3.NO_BA_LAPANGAN as no_ba_lapangan2, SK3.TGL_BA_LAPANGAN as tgl_ba_lapangan2
FROM PST_PERMOHONAN A, PST_DETAIL B, PST_PERMOHONAN_PENGURANGAN C,
SK_SK SK, PENGURANGAN_PERMANEN PERMANEN,
SK_SK SK2, PENGURANGAN_PST PENGURANGAN,
SK_SK SK3, PENGURANGAN_PENGENAAN_JPB PENGURANGAN_JPB
WHERE ((B.NO_URUT_PELAYANAN = A.NO_URUT_PELAYANAN
AND B.BUNDEL_PELAYANAN = A.BUNDEL_PELAYANAN
AND B.THN_PELAYANAN = A.THN_PELAYANAN
AND B.KD_KANTOR = A.KD_KANTOR
AND B.KD_KANWIL = A.KD_KANWIL
and B.kd_jns_pelayanan='08'
and A.status_kolektif='1')
AND (C.KD_KANWIL = B.KD_KANWIL)
AND (C.KD_KANTOR = B.KD_KANTOR)
AND (C.THN_PELAYANAN = B.THN_PELAYANAN)
AND (C.BUNDEL_PELAYANAN = B.BUNDEL_PELAYANAN)
AND (C.NO_URUT_PELAYANAN = B.NO_URUT_PELAYANAN)
AND (C.KD_PROPINSI_PEMOHON = B.KD_PROPINSI_PEMOHON)
AND (C.KD_DATI2_PEMOHON = B.KD_DATI2_PEMOHON)
AND (C.KD_KECAMATAN_PEMOHON = B.KD_KECAMATAN_PEMOHON)
AND (C.KD_KELURAHAN_PEMOHON = B.KD_KELURAHAN_PEMOHON)
AND (C.KD_BLOK_PEMOHON = B.KD_BLOK_PEMOHON)
AND (C.NO_URUT_PEMOHON = B.NO_URUT_PEMOHON)
AND (C.KD_JNS_OP_PEMOHON = B.KD_JNS_OP_PEMOHON)
and (C.jns_pengurangan ='3'))
and
(PERMANEN.NO_SK=SK.NO_SK
AND PERMANEN.JNS_SK=SK.JNS_SK
AND PERMANEN.KD_KANTOR=SK.KD_KANTOR
AND PERMANEN.KD_KANWIL=SK.KD_KANWIL)
AND
(PENGURANGAN.NO_SK=SK2.NO_SK
AND PENGURANGAN.JNS_SK=SK2.JNS_SK
AND PENGURANGAN.KD_KANTOR=SK2.KD_KANTOR
AND PENGURANGAN.KD_KANWIL=SK2.KD_KANWIL)
AND
(PENGURANGAN_JPB.NO_SK=SK3.NO_SK
AND PENGURANGAN_JPB.JNS_SK=SK3.JNS_SK
AND PENGURANGAN_JPB.KD_KANTOR=SK3.KD_KANTOR
AND PENGURANGAN_JPB.KD_KANWIL=SK3.KD_KANWIL)
) K
WHERE EXISTS(SELECT * FROM LOG_KELUARAN_PST L
WHERE L.KD_KANWIL = $P{kd_kanwil}
AND L.KD_KANTOR = $P{kd_kantor}
AND L.THN_PELAYANAN||L.BUNDEL_PELAYANAN||L.NO_URUT_PELAYANAN||L.KD_PROPINSI_PEMOHON||L.KD_DATI2_PEMOHON||L.KD_KECAMATAN_PEMOHON||L.KD_KELURAHAN_PEMOHON||L.KD_BLOK_PEMOHON||L.NO_URUT_PEMOHON||L.KD_JNS_OP_PEMOHON BETWEEN $P{thn_pelayanan_awal}||$P{bundel_pelayanan_awal}||$P{no_urut_pelayanan_awal}||$P{kd_propinsi_awal}||$P{kd_dati2_awal}||$P{kd_kecamatan_awal}||$P{kd_kelurahan_awal}||$P{kd_blok_awal}||$P{no_urut_awal}||$P{kd_jns_op_awal} AND $P{thn_pelayanan_akhir}||$P{bundel_pelayanan_akhir}||$P{no_urut_pelayanan_akhir}||$P{kd_propinsi_akhir}||$P{kd_dati2_akhir}||$P{kd_kecamatan_akhir}||$P{kd_kelurahan_akhir}||$P{kd_blok_akhir}||$P{no_urut_akhir}||$P{kd_jns_op_akhir} AND
K.KD_KANWIL = L.KD_KANWIL AND
K.KD_KANTOR = L.KD_KANTOR AND
K.THN_PELAYANAN = L.THN_PELAYANAN AND
K.BUNDEL_PELAYANAN = L.BUNDEL_PELAYANAN AND
K.NO_URUT_PELAYANAN = L.NO_URUT_PELAYANAN AND
K.KD_PROPINSI_PEMOHON = L.KD_PROPINSI_PEMOHON AND
K.KD_DATI2_PEMOHON = L.KD_DATI2_PEMOHON AND
K.KD_KECAMATAN_PEMOHON = L.KD_KECAMATAN_PEMOHON AND
K.KD_KELURAHAN_PEMOHON = L.KD_KELURAHAN_PEMOHON AND
K.KD_BLOK_PEMOHON = L.KD_BLOK_PEMOHON AND
K.NO_URUT_PEMOHON = L.NO_URUT_PEMOHON AND
K.KD_JNS_OP_PEMOHON= L.KD_JNS_OP_PEMOHON)]]>
</queryString>
<field name="status_kolektif" class="java.lang.String"/>
<field name="no_srt_permohonan" class="java.lang.String"/>
<field name="tgl_surat_permohonan" class="java.sql.Timestamp"/>
<field name="tgl_terima_dokumen_wp" class="java.sql.Timestamp"/>
<field name="kd_jns_pelayanan" class="java.lang.String"/>
<field name="thn_pajak_permohonan" class="java.lang.String"/>
<field name="kd_kanwil" class="java.lang.String"/>
<field name="kd_kantor" class="java.lang.String"/>
<field name="thn_pelayanan" class="java.lang.String"/>
<field name="bundel_pelayanan" class="java.lang.String"/>
<field name="no_urut_pelayanan" class="java.lang.String"/>
<field name="kd_propinsi_pemohon" class="java.lang.String"/>
<field name="kd_dati2_pemohon" class="java.lang.String"/>
<field name="kd_kecamatan_pemohon" class="java.lang.String"/>
<field name="kd_kelurahan_pemohon" class="java.lang.String"/>
<field name="kd_blok_pemohon" class="java.lang.String"/>
<field name="no_urut_pemohon" class="java.lang.String"/>
<field name="kd_jns_op_pemohon" class="java.lang.String"/>
<field name="jns_pengurangan" class="java.lang.String"/>
<field name="jns_sk" class="java.lang.String"/>
<field name="no_sk" class="java.lang.String"/>
<field name="tgl_sk" class="java.sql.Timestamp"/>
<field name="no_ba_kantor" class="java.lang.String"/>
<field name="tgl_ba_kantor" class="java.sql.Timestamp"/>
<field name="no_ba_lapangan" class="java.lang.String"/>
<field name="tgl_ba_lapangan" class="java.sql.Timestamp"/>
<field name="jns_sk1" class="java.lang.String"/>
<field name="no_sk1" class="java.lang.String"/>
<field name="tgl_sk1" class="java.sql.Timestamp"/>
<field name="no_ba_kantor1" class="java.lang.String"/>
<field name="tgl_ba_kantor1" class="java.sql.Timestamp"/>
<field name="no_ba_lapangan1" class="java.lang.String"/>
<field name="tgl_ba_lapangan1" class="java.sql.Timestamp"/>
<field name="jns_sk2" class="java.lang.String"/>
<field name="no_sk2" class="java.lang.String"/>
<field name="tgl_sk2" class="java.sql.Timestamp"/>
<field name="no_ba_kantor2" class="java.lang.String"/>
<field name="tgl_ba_kantor2" class="java.sql.Timestamp"/>
<field name="no_ba_lapangan2" class="java.lang.String"/>
<field name="tgl_ba_lapangan2" class="java.sql.Timestamp"/>
<variable name="menimbang" class="java.lang.String">
<variableExpression><![CDATA[(($V{vlc_tgl_ba_kantor}!=null || $V{vlc_tgl_ba_kantor}!='') && ($V{vlc_tgl_ba_lapangan}==null || $V{vlc_tgl_ba_lapangan}=='')) ?
"Hasil pemeriksaan sederhana sederhana kantor permohonan pengurangan pajak sebagaimana dalam Berita Acara pemeriksaan sederhana kantor tanggal "+$V{vlc_tanggal1}+" "+$V{vlc_bulan12}+" "+$V{vlc_tahun1}+", Nomor : "+$V{vlc_no_ba_kantor} : (
(($V{vlc_tgl_ba_kantor}==null || $V{vlc_tgl_ba_kantor}=='') && ($V{vlc_tgl_ba_lapangan}!=null || $V{vlc_tgl_ba_lapangan}!='')) ?
"Hasil pemeriksaan sederhana lapangan permohonan pengurangan pajak sebagaimana dalam Berita Acara Pemeriksaan Sederhana Lapangan tanggal"+$V{vlc_tanggal2}+" "+$V{vlc_blndua2}+" "+$V{vlc_tahun2}+", Nomor : "+$V{vlc_no_ba_lapangan} : (
(($V{vlc_tgl_ba_kantor}!=null || $V{vlc_tgl_ba_kantor}!='') && ($V{vlc_tgl_ba_lapangan}!=null || $V{vlc_tgl_ba_lapangan}!='')) ?
"Hasil pemeriksaan sederhana kantor/pemeriksaan sederhana lapangan permohonan pengurangan pajak sebagaimana dalam Berita Acara Pemeriksaan Sederhana Kantor tanggal "+$V{vlc_tanggal1}+" "+$V{vlc_bulan12}+" "+$V{vlc_tahun1}+", Nomor : "+$V{vlc_no_ba_kantor}+" dan Berita Acara Pemeriksaan Sederhana Lapangan tanggal "+$V{vlc_tanggal2}+" "+$V{vlc_blndua2}+" "+$V{vlc_tahun2}+", Nomor : "+$V{vlc_no_ba_lapangan} :
"Hasil pemeriksaan sederhana kantor/pemeriksaan sederhana lapangan permohonan pengurangan pajak sebagaimana dalam Berita Acara Pemeriksaan Sederhana Kantor/Pemeriksaan Sederhana Lapangan tanggal .../.../......, Nomor : ......................................"
)
)]]></variableExpression>
</variable>
<variable name="vlc_jns_sk" class="java.lang.String">
<variableExpression><![CDATA[($F{jns_pengurangan} == '1') ? $F{jns_sk} : (
($F{jns_pengurangan} == '3') ? $F{jns_sk2} : (
($F{jns_pengurangan} == '2' || $F{jns_pengurangan} == '5') ? $F{jns_sk1} : ""
)
)]]></variableExpression>
</variable>
<variable name="vlc_no_sk" class="java.lang.String">
<variableExpression><![CDATA[($F{jns_pengurangan} == '1') ? $F{no_sk} : (
($F{jns_pengurangan} == '3') ? $F{no_sk2} : (
($F{jns_pengurangan} == '2' || $F{jns_pengurangan} == '5') ? $F{no_sk1} : ""
)
)]]></variableExpression>
</variable>
<variable name="vlc_tgl_sk" class="java.sql.Timestamp">
<variableExpression><![CDATA[($F{jns_pengurangan} == '1') ? $F{tgl_sk} : (
($F{jns_pengurangan} == '3') ? $F{tgl_sk2} : (
($F{jns_pengurangan} == '2' || $F{jns_pengurangan} == '5') ? $F{tgl_sk1} : ""
)
)]]></variableExpression>
</variable>
<variable name="vlc_no_ba_kantor" class="java.lang.String">
<variableExpression><![CDATA[($F{jns_pengurangan} == '1') ? $F{no_ba_kantor} : (
($F{jns_pengurangan} == '3') ? $F{no_ba_kantor2} : (
($F{jns_pengurangan} == '2' || $F{jns_pengurangan} == '5') ? $F{no_ba_kantor1} : ""
)
)]]></variableExpression>
</variable>
<variable name="vlc_tgl_ba_kantor" class="java.sql.Timestamp">
<variableExpression><![CDATA[($F{jns_pengurangan} == '1') ? $F{tgl_ba_kantor} : (
($F{jns_pengurangan} == '3') ? $F{tgl_ba_kantor} : (
($F{jns_pengurangan} == '2' || $F{jns_pengurangan} == '5') ? $F{tgl_ba_kantor} : ""
)
)]]></variableExpression>
</variable>
<variable name="vlc_no_ba_lapangan" class="java.lang.String">
<variableExpression><![CDATA[($F{jns_pengurangan} == '1') ? $F{no_ba_lapangan} : (
($F{jns_pengurangan} == '3') ? $F{no_ba_lapangan2} : (
($F{jns_pengurangan} == '2' || $F{jns_pengurangan} == '5') ? $F{no_ba_lapangan1} : ""
)
)]]></variableExpression>
</variable>
<variable name="vlc_tgl_ba_lapangan" class="java.sql.Timestamp">
<variableExpression><![CDATA[($F{jns_pengurangan} == '1') ? $F{tgl_ba_lapangan} : (
($F{jns_pengurangan} == '3') ? $F{tgl_ba_lapangan2} : (
($F{jns_pengurangan} == '2' || $F{jns_pengurangan} == '5') ? $F{tgl_ba_lapangan1} : ""
)
)]]></variableExpression>
</variable>
<variable name="vlc_tanggal" class="java.lang.Integer">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("dd").format($V{vlc_tgl_sk}))]]></variableExpression>
</variable>
<variable name="vlc_bln" class="java.lang.Integer">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("MM").format($V{vlc_tgl_sk}))]]></variableExpression>
</variable>
<variable name="vlc_tahun" class="java.lang.Integer">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("yyyy").format($V{vlc_tgl_sk}))]]></variableExpression>
</variable>
<variable name="vlc_bln2" class="java.lang.String">
<variableExpression><![CDATA[($V{vlc_bln} == 1) ? "JANUARI" : (
($V{vlc_bln} == 2) ? "PEBRUARI" : (
($V{vlc_bln} == 3) ? "MARET" : (
($V{vlc_bln} == 4) ? "APRIL" : (
($V{vlc_bln} == 5) ? "MEI" : (
($V{vlc_bln} == 6) ? "JUNI" : (
($V{vlc_bln} == 7) ? "JULI" : (
($V{vlc_bln} == 8) ? "AGUSTUS" : (
($V{vlc_bln} == 9) ? "SEPTEMBER" : (
($V{vlc_bln} == 10) ? "OKTOBER" : (
($V{vlc_bln} == 11) ? "NOVEMBER" : "DESEMBER"
)
)
)
)
)
)
)
)
)
)]]></variableExpression>
</variable>
<variable name="vlc_tanggal1" class="java.lang.Integer">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("dd").format($V{vlc_tgl_ba_kantor}))]]></variableExpression>
</variable>
<variable name="vlc_bln1" class="java.lang.Integer">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("MM").format($V{vlc_tgl_ba_kantor}))]]></variableExpression>
</variable>
<variable name="vlc_tahun1" class="java.lang.Integer">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("yyyy").format($V{vlc_tgl_ba_kantor}))]]></variableExpression>
</variable>
<variable name="vlc_bulan12" class="java.lang.String">
<variableExpression><![CDATA[($V{vlc_bln1} == 1) ? "JANUARI" : (
($V{vlc_bln1} == 2) ? "PEBRUARI" : (
($V{vlc_bln1} == 3) ? "MARET" : (
($V{vlc_bln1} == 4) ? "APRIL" : (
($V{vlc_bln1} == 5) ? "MEI" : (
($V{vlc_bln1} == 6) ? "JUNI" : (
($V{vlc_bln1} == 7) ? "JULI" : (
($V{vlc_bln1} == 8) ? "AGUSTUS" : (
($V{vlc_bln1} == 9) ? "SEPTEMBER" : (
($V{vlc_bln1} == 10) ? "OKTOBER" : (
($V{vlc_bln1} == 11) ? "NOVEMBER" : "DESEMBER"
)
)
)
)
)
)
)
)
)
)]]></variableExpression>
</variable>
<variable name="vlc_tanggal2" class="java.lang.Integer">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("dd").format($V{vlc_tgl_ba_lapangan}))]]></variableExpression>
</variable>
<variable name="vlc_blndua" class="java.lang.Integer">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("MM").format($V{vlc_tgl_ba_lapangan}))]]></variableExpression>
</variable>
<variable name="vlc_tahun2" class="java.lang.Integer">
<variableExpression><![CDATA[new Integer(new SimpleDateFormat("yyyy").format($V{vlc_tgl_ba_lapangan}))]]></variableExpression>
</variable>
<variable name="vlc_blndua2" class="java.lang.String">
<variableExpression><![CDATA[($V{vlc_blndua} == 1) ? "JANUARI" : (
($V{vlc_blndua} == 2) ? "PEBRUARI" : (
($V{vlc_blndua} == 3) ? "MARET" : (
($V{vlc_blndua} == 4) ? "APRIL" : (
($V{vlc_blndua} == 5) ? "MEI" : (
($V{vlc_blndua} == 6) ? "JUNI" : (
($V{vlc_blndua} == 7) ? "JULI" : (
($V{vlc_blndua} == 8) ? "AGUSTUS" : (
($V{vlc_blndua} == 9) ? "SEPTEMBER" : (
($V{vlc_blndua} == 10) ? "OKTOBER" : (
($V{vlc_blndua} == 11) ? "NOVEMBER" : "DESEMBER"
)
)
)
)
)
)
)
)
)
)]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="1607" splitType="Stretch">
<staticText>
<reportElement uuid="71dcdf73-b629-4d8e-a75f-323b566d7849" x="0" y="126" width="572" height="34"/>
<textElement textAlignment="Center">
<font fontName="Courier New" isBold="true"/>
</textElement>
<text><![CDATA[TENTANG
PEMBERIAN PENGURANGAN
PAJAK BUMI DAN BANGUNAN YANG TERUTANG]]></text>
</staticText>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="0" y="193" width="128" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Memperhatikan :]]></text>
</staticText>
<staticText>
<reportElement uuid="8a8fef92-da1a-4c69-878a-23442522c551" x="128" y="193" width="421" height="14"/>
<textElement textAlignment="Justified">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Surat permohonan keberatan terhadap pajak terutang tanngal]]></text>
</staticText>
<subreport>
<reportElement uuid="90fddaa9-997a-4974-8b6c-5670846e70e9" x="128" y="205" width="421" height="14"/>
<subreportParameter name="kd_kanwil">
<subreportParameterExpression><![CDATA[$F{kd_kanwil}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kantor">
<subreportParameterExpression><![CDATA[$F{kd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_pelayanan">
<subreportParameterExpression><![CDATA[$F{thn_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="bundel_pelayanan">
<subreportParameterExpression><![CDATA[$F{bundel_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut_pelayanan">
<subreportParameterExpression><![CDATA[$F{no_urut_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan_Nopel.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="8a8fef92-da1a-4c69-878a-23442522c551" x="128" y="219" width="72" height="14"/>
<textElement textAlignment="Justified">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Wajib Pajak]]></text>
</staticText>
<subreport>
<reportElement uuid="8ac05ca5-538a-44ac-bef7-801ec58f71c5" x="200" y="219" width="283" height="14"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_blok">
<subreportParameterExpression><![CDATA[$F{kd_blok_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut">
<subreportParameterExpression><![CDATA[$F{no_urut_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_jns_op">
<subreportParameterExpression><![CDATA[$F{kd_jns_op_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan_nmwp.jasper"]]></subreportExpression>
</subreport>
<textField>
<reportElement uuid="a048a8a7-f5eb-48a7-a489-9f97649debc3" x="0" y="93" width="572" height="13"/>
<textElement textAlignment="Center">
<font fontName="Courier New" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA["NOMOR : KEP-"+$F{no_sk}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="0" y="363" width="128" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Mengingat :]]></text>
</staticText>
<subreport>
<reportElement uuid="001d2f9c-21bb-400c-b62e-7d808962f173" x="128" y="363" width="421" height="55"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan_mengingat.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="3febac54-9243-4cf3-8664-5efcb55ab959" x="266" y="458" width="67" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[MEMUTUSKAN]]></text>
</staticText>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="0" y="503" width="128" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Menetapkan :]]></text>
</staticText>
<subreport>
<reportElement uuid="c6d3a063-ea6d-4ffa-8c2a-8afc3677674a" x="128" y="503" width="421" height="31"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan_menetapkan.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="3febac54-9243-4cf3-8664-5efcb55ab959" x="266" y="613" width="67" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Pasal 1]]></text>
</staticText>
<staticText>
<reportElement uuid="4d21607f-765d-4019-a5de-35d94b107eb1" x="154" y="683" width="145" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nama Wajib Pajak :]]></text>
</staticText>
<subreport>
<reportElement uuid="378ee5f6-8f19-461b-a128-5910cbd5ef2f" x="299" y="683" width="231" height="13"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_blok">
<subreportParameterExpression><![CDATA[$F{kd_blok_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut">
<subreportParameterExpression><![CDATA[$F{no_urut_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_jns_op">
<subreportParameterExpression><![CDATA[$F{kd_jns_op_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan_nmwp.jasper"]]></subreportExpression>
</subreport>
<textField>
<reportElement uuid="a8a2829c-d037-4ab9-a52d-7eb55c3e842c" x="148" y="252" width="401" height="56"/>
<textElement textAlignment="Justified">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{menimbang}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="3febac54-9243-4cf3-8664-5efcb55ab959" x="266" y="1137" width="67" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Pasal 2]]></text>
</staticText>
<textField>
<reportElement uuid="4edd863b-d017-4d81-bedf-761324e201fe" x="128" y="1161" width="421" height="26"/>
<textElement textAlignment="Justified">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["Apabila dikemudian hari ternyata terdapat kekeliruan dalam Keputusan ini maka akan dibetulkan sebagaimana mestinya."]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="c99ee7c4-3f62-46ba-9a7c-ba7e5751ee79" x="314" y="1279" width="92" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Ditetapkan di :]]></text>
</staticText>
<componentElement>
<reportElement uuid="08b9f1f9-ee93-4c8f-b50c-917e2fe88f45" x="406" y="1279" width="166" height="13"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset1" uuid="8523ea82-62fa-47a1-b6a0-f65fb764c486">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$F{kd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kantor">
<datasetParameterExpression><![CDATA[$F{kd_kantor}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="13" width="166">
<textField>
<reportElement uuid="3d273441-abfc-4add-b11c-c37512902608" x="0" y="0" width="166" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kota_terbit}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="c99ee7c4-3f62-46ba-9a7c-ba7e5751ee79" x="314" y="1291" width="92" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Pada tanggal :]]></text>
</staticText>
<textField>
<reportElement uuid="bd54f512-8abb-4045-9a2d-6fb7510bdc14" x="406" y="1291" width="166" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{vlc_tanggal}.toString()+" "+$V{vlc_bln2}+" "+$V{vlc_tahun}.toString()]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="ab1229e8-b2f4-4b26-b175-22038ea7afc3" x="314" y="1331" width="100" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kepala Dinas]]></text>
</staticText>
<componentElement>
<reportElement uuid="e301d72f-fbad-4fb0-ad8a-d7201388ce55" x="314" y="1394" width="258" height="27"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset2" uuid="82439995-69c7-4103-b444-82c1fde6a0b4">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$F{kd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kantor">
<datasetParameterExpression><![CDATA[$F{kd_kantor}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="27" width="258">
<textField>
<reportElement uuid="b8643334-50f2-4cce-9813-e9e71a5944af" x="0" y="0" width="258" height="13"/>
<textElement verticalAlignment="Middle">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_pegawai}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="68552fcd-d859-42a2-af93-a84d9be40df7" x="0" y="13" width="163" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="9127a142-4ab5-4b29-ba7a-a069c27b8917" x="0" y="13" width="258" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nip}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="0fd18319-06c0-4665-9c2c-ec4bbe1bb1ce" x="0" y="1484" width="340" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tembusan Surat Keputusan ini disampaikan kepada Yth.:]]></text>
</staticText>
<componentElement>
<reportElement uuid="005ba631-edf8-4b36-82a6-0d44353d7786" x="0" y="1496" width="400" height="12"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset3" uuid="01110e6c-68cd-440f-a62e-73c5b6606503">
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="400">
<textField>
<reportElement uuid="71eeb55a-1f08-4130-8e6c-c1b95374f5d5" x="0" y="0" width="272" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_ref}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="34db55ff-dcc3-4a81-96df-a1f281d4bcfb" x="0" y="1507" width="400" height="13"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset4" uuid="78d3ba7f-ab52-4338-8c97-3be069a26887">
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="13" width="400">
<textField>
<reportElement uuid="07638785-556e-4dde-831b-335b00d41d0b" x="0" y="0" width="272" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_ref}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="d41d735e-6ae6-4516-a298-9917f7174831" x="0" y="1520" width="400" height="14"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset5" uuid="d225b432-8920-4e9e-8dc9-a43f1a60fef1">
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="14" width="400">
<textField>
<reportElement uuid="fdaf75ce-b836-4459-bb26-9a16fcc651fc" x="0" y="0" width="272" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_ref}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="2754c420-fa02-4b05-b909-f87d7183ac36" x="0" y="1533" width="400" height="16"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset6" uuid="a3230914-c2a0-4fb6-ba6e-59de0426cf72">
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="16" width="400">
<textField>
<reportElement uuid="c8f3b9ab-6f9a-4b2d-a676-1627895ce317" x="0" y="1" width="272" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_ref}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<subreport>
<reportElement uuid="2a37fea5-0f30-4e67-b894-94b476eebc1b" x="0" y="0" width="572" height="19"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan2.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="59a3ac45-0749-415e-9bdb-fce96c080193" x="0" y="19" width="572" height="17"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan3.jasper"]]></subreportExpression>
</subreport>
<subreport>
<reportElement uuid="fceeb5b5-2c0f-49dc-9ae1-7b6d2cdfff35" x="0" y="38" width="572" height="17"/>
<subreportParameter name="kd_kantor">
<subreportParameterExpression><![CDATA[$P{kd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan_kantor.jasper"]]></subreportExpression>
</subreport>
<line>
<reportElement uuid="927efe3a-0e49-4105-b2f2-5616e41c4767" mode="Transparent" x="3" y="57" width="566" height="1"/>
</line>
<staticText>
<reportElement uuid="61612668-3813-4bf3-b8e0-9b884ad355e0" x="127" y="80" width="103" height="13"/>
<textElement>
<font fontName="Courier New" isBold="true"/>
</textElement>
<text><![CDATA[KEPUTUSAN KEPALA]]></text>
</staticText>
<subreport>
<reportElement uuid="0378f75b-bdf8-4fcc-90a4-4e7cc4ef3650" x="230" y="80" width="203" height="13"/>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan_kop2.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="3" y="252" width="128" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Menimbang :]]></text>
</staticText>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="131" y="252" width="13" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[a.]]></text>
</staticText>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="131" y="316" width="13" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[b.]]></text>
</staticText>
<staticText>
<reportElement uuid="ed370514-9b89-4ce5-8dcb-9bde6e8c926b" x="148" y="316" width="401" height="27"/>
<textElement textAlignment="Justified">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[bahwa setelah dipertimbangkan, maka besarnya pajak yang disetujui perlu ditetapkan dengan Keputusan Kepala Dinas.]]></text>
</staticText>
<subreport>
<reportElement uuid="be9d3f08-2699-46fc-bf80-5e084dc4e431" x="154" y="696" width="408" height="104"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_blok">
<subreportParameterExpression><![CDATA[$F{kd_blok_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut">
<subreportParameterExpression><![CDATA[$F{no_urut_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_jns_op">
<subreportParameterExpression><![CDATA[$F{kd_jns_op_pemohon}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_pelayanan">
<subreportParameterExpression><![CDATA[$F{thn_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="bundel_pelayanan">
<subreportParameterExpression><![CDATA[$F{bundel_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut_pelayanan">
<subreportParameterExpression><![CDATA[$F{no_urut_pelayanan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kanwil">
<subreportParameterExpression><![CDATA[$F{kd_kanwil}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kantor">
<subreportParameterExpression><![CDATA[$F{kd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_pajak_permohonan">
<subreportParameterExpression><![CDATA[$F{thn_pajak_permohonan}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA[$P{SUBREPORT_DIR} + "Keberatan_wp.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="141" y="683" width="13" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[a.]]></text>
</staticText>
<staticText>
<reportElement uuid="4d21607f-765d-4019-a5de-35d94b107eb1" x="153" y="816" width="139" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Letak Tanah/Bangunan :]]></text>
</staticText>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="141" y="816" width="13" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[b.]]></text>
</staticText>
<componentElement>
<reportElement uuid="5a0d699d-ed2c-4bc8-b93b-0c2f40613fae" x="291" y="816" width="270" height="13"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset7" uuid="5cf8e6e5-9617-4c39-9db7-eeb15374b035">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$F{kd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kantor">
<datasetParameterExpression><![CDATA[$F{kd_kantor}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pelayanan">
<datasetParameterExpression><![CDATA[$F{thn_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="bundel_pelayanan">
<datasetParameterExpression><![CDATA[$F{bundel_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut_pelayanan">
<datasetParameterExpression><![CDATA[$F{no_urut_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_blok">
<datasetParameterExpression><![CDATA[$F{kd_blok_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut">
<datasetParameterExpression><![CDATA[$F{no_urut_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_jns_op">
<datasetParameterExpression><![CDATA[$F{kd_jns_op_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="13" width="270">
<textField>
<reportElement uuid="b75edb78-8c68-41fd-847d-a3df59463e26" x="0" y="0" width="270" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{al_op}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="4d21607f-765d-4019-a5de-35d94b107eb1" x="153" y="828" width="139" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[RT/RW :]]></text>
</staticText>
<componentElement>
<reportElement uuid="ee8d3334-b02e-43fe-b236-c0294873165e" x="291" y="828" width="270" height="13"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset8" uuid="29c5e127-ad61-41b3-89c0-7ba0cd02256c">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$F{kd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kantor">
<datasetParameterExpression><![CDATA[$F{kd_kantor}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pelayanan">
<datasetParameterExpression><![CDATA[$F{thn_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="bundel_pelayanan">
<datasetParameterExpression><![CDATA[$F{bundel_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut_pelayanan">
<datasetParameterExpression><![CDATA[$F{no_urut_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_blok">
<datasetParameterExpression><![CDATA[$F{kd_blok_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut">
<datasetParameterExpression><![CDATA[$F{no_urut_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_jns_op">
<datasetParameterExpression><![CDATA[$F{kd_jns_op_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="13" width="270">
<textField>
<reportElement uuid="b3b9ef61-ace0-45ca-85c8-ce6564c96b14" x="1" y="1" width="269" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{rt_rw}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="4d21607f-765d-4019-a5de-35d94b107eb1" x="153" y="841" width="139" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kelurahan/Desa :]]></text>
</staticText>
<componentElement>
<reportElement uuid="5b9d1eed-ffd5-4062-913f-7c021dc63a01" x="291" y="841" width="270" height="13"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset9" uuid="69db22b5-a3c1-4def-a0c4-46241f9a53df">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="13" width="270">
<textField>
<reportElement uuid="034260ea-fe61-490d-8b5b-632e54a72271" x="0" y="0" width="270" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="4d21607f-765d-4019-a5de-35d94b107eb1" x="153" y="854" width="139" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kecamatan :]]></text>
</staticText>
<componentElement>
<reportElement uuid="4b4c4390-2a68-402a-82dd-286f7a60bb66" x="291" y="854" width="270" height="13"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset10" uuid="f8b5c1aa-7636-4395-b108-6f62b9467e89">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="13" width="270">
<textField>
<reportElement uuid="1898da2f-9b9a-433c-9555-96ec7dd811a4" x="1" y="0" width="269" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kecamatan}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="4d21607f-765d-4019-a5de-35d94b107eb1" x="153" y="867" width="139" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kota/Kabupaten :]]></text>
</staticText>
<componentElement>
<reportElement uuid="456f33ef-a778-4a68-a11e-d57520e4a974" x="291" y="867" width="270" height="13"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset11" uuid="44fa9760-9c41-4b2b-bc9a-9c0a64de2149">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="13" width="270">
<textField>
<reportElement uuid="b46021f3-a031-4e9b-b266-a84401feae24" x="1" y="0" width="269" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_dati2}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="4d21607f-765d-4019-a5de-35d94b107eb1" x="153" y="880" width="139" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Propinsi :]]></text>
</staticText>
<componentElement>
<reportElement uuid="85c83695-8666-4c38-8142-d21694dca975" x="291" y="880" width="270" height="13"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset12" uuid="24d461b4-0559-4f3a-b008-7f70121d9464">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="13" width="270">
<textField>
<reportElement uuid="accfe248-b7c6-4b85-9796-16640a6d45f5" x="1" y="0" width="269" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_propinsi}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="62c4b4e4-d5c0-447c-9f72-fcd5215bcbd2" x="141" y="639" width="400" height="33"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset13" uuid="1b1737aa-e1a7-4a2a-a83b-3cc854f7844a">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$F{kd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kantor">
<datasetParameterExpression><![CDATA[$F{kd_kantor}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pelayanan">
<datasetParameterExpression><![CDATA[$F{thn_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="bundel_pelayanan">
<datasetParameterExpression><![CDATA[$F{bundel_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_blok">
<datasetParameterExpression><![CDATA[$F{kd_blok_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut">
<datasetParameterExpression><![CDATA[$F{no_urut_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_jns_op">
<datasetParameterExpression><![CDATA[$F{kd_jns_op_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="33" width="400">
<textField>
<reportElement uuid="36c75133-e793-492f-a451-d1891a167b60" x="0" y="0" width="400" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{status}+"Permohonan Pengurangan Pajak Bumi dan Bangunan yang terutang kepada :"]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<line>
<reportElement uuid="b901b2b9-0a1d-4622-a565-d811954abc65" x="318" y="1039" width="165" height="1"/>
<graphicElement>
<pen lineWidth="0.5"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="2a6f944e-b033-4ca3-862a-403a73a20528" x="154" y="1052" width="144" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Jumlah pajak terutang]]></text>
</staticText>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="140" y="966" width="13" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[a.]]></text>
</staticText>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="142" y="1052" width="13" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[c.]]></text>
</staticText>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="141" y="1000" width="13" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[b.]]></text>
</staticText>
<staticText>
<reportElement uuid="2a6f944e-b033-4ca3-862a-403a73a20528" x="153" y="1000" width="144" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Besarnya pengurangan]]></text>
</staticText>
<staticText>
<reportElement uuid="2a6f944e-b033-4ca3-862a-403a73a20528" x="153" y="966" width="144" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Pajak terhutang menurut]]></text>
</staticText>
<staticText>
<reportElement uuid="36ec3402-66a9-49c1-965b-b9e6154039f6" x="121" y="917" width="20" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[(2)]]></text>
</staticText>
<staticText>
<reportElement uuid="2a6f944e-b033-4ca3-862a-403a73a20528" x="153" y="978" width="144" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[SPPT]]></text>
</staticText>
<textField>
<reportElement uuid="f22afe0b-2282-4e91-9e31-58d53efce8c4" x="141" y="917" width="417" height="28"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["Sesuai dengan ketentuan ayat (1) di atas, maka besarnya PBB terutang adalah sebagai berikut :"]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="2a6f944e-b033-4ca3-862a-403a73a20528" x="154" y="1064" width="156" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[setelah pengurangan (a-b)]]></text>
</staticText>
<staticText>
<reportElement uuid="2a6f944e-b033-4ca3-862a-403a73a20528" x="153" y="1012" width="144" height="13"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[(... % x Rp ....)]]></text>
</staticText>
<componentElement>
<reportElement uuid="2e64db05-0fc0-4f6c-ae38-60a7b05d6cb9" x="318" y="978" width="165" height="13"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset14" uuid="812f064c-9039-45d7-8e80-e103ddb6d56e">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$F{kd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kantor">
<datasetParameterExpression><![CDATA[$F{kd_kantor}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pelayanan">
<datasetParameterExpression><![CDATA[$F{thn_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="bundel_pelayanan">
<datasetParameterExpression><![CDATA[$F{bundel_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut_pelayanan">
<datasetParameterExpression><![CDATA[$F{no_urut_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_blok">
<datasetParameterExpression><![CDATA[$F{kd_blok_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut">
<datasetParameterExpression><![CDATA[$F{no_urut_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_jns_op">
<datasetParameterExpression><![CDATA[$F{kd_jns_op_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="13" width="165">
<textField>
<reportElement uuid="7afe7177-4968-4d3a-b801-2dff9dde0574" x="0" y="0" width="165" height="13"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["Rp. "+new java.text.DecimalFormat("#,##0").format($F{pbb_yg_harus_dibayar}.doubleValue())]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="224eaf62-615e-416f-813d-f37e63f94c89" x="318" y="1012" width="165" height="13"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset15" uuid="1f182d4a-6702-4f6f-9d74-1740458cb3b8">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$F{kd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kantor">
<datasetParameterExpression><![CDATA[$F{kd_kantor}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pelayanan">
<datasetParameterExpression><![CDATA[$F{thn_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="bundel_pelayanan">
<datasetParameterExpression><![CDATA[$F{bundel_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut_pelayanan">
<datasetParameterExpression><![CDATA[$F{no_urut_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_blok">
<datasetParameterExpression><![CDATA[$F{kd_blok_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut">
<datasetParameterExpression><![CDATA[$F{no_urut_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_jns_op">
<datasetParameterExpression><![CDATA[$F{kd_jns_op_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="13" width="165">
<textField>
<reportElement uuid="bc43f5b3-bf8f-4b19-befc-a872d5031d90" x="0" y="0" width="165" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["Rp. "+new java.text.DecimalFormat("#,##0").format($F{pengurangan}.doubleValue())]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<componentElement>
<reportElement uuid="b94d5e45-2c00-495b-948a-ad7917c8bc17" x="318" y="1065" width="165" height="12"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="dataset16" uuid="89b98167-4923-4d18-8d4f-ba8f6550ca26">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$F{kd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kantor">
<datasetParameterExpression><![CDATA[$F{kd_kantor}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="thn_pelayanan">
<datasetParameterExpression><![CDATA[$F{thn_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="bundel_pelayanan">
<datasetParameterExpression><![CDATA[$F{bundel_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut_pelayanan">
<datasetParameterExpression><![CDATA[$F{no_urut_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$F{kd_propinsi_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$F{kd_dati2_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$F{kd_kecamatan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kelurahan">
<datasetParameterExpression><![CDATA[$F{kd_kelurahan_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_blok">
<datasetParameterExpression><![CDATA[$F{kd_blok_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="no_urut">
<datasetParameterExpression><![CDATA[$F{no_urut_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_jns_op">
<datasetParameterExpression><![CDATA[$F{kd_jns_op_pemohon}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="12" width="165">
<textField>
<reportElement uuid="48475dd0-2ed8-42b7-8f60-b91c39c371d5" x="0" y="0" width="165" height="12"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["Rp. "+new java.text.DecimalFormat("#,##0").format($F{pbb_setelah_terhutang}.doubleValue())]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<break>
<reportElement uuid="960c1a55-e5d9-40d2-a662-9b3e123e2c89" positionType="FixRelativeToBottom" x="0" y="557" width="100" height="1"/>
</break>
</band>
</detail>
</jasperReport>