= '23') OR (A01 = $P{END_DATE} and substr(A02,1,2) < '23'))) AS CORE FULL JOIN (SELECT DATE(A01)PRIMA01,(A02)PRIMA02,(A03)PRIMA03,(A04)PRIMA04,(A05)PRIMA05,(A06)PRIMA06,(A07)PRIMA07,(A08)PRIMA08,(A09)PRIMA09, (A10)PRIMA10, (A11)PRIMA11, (A12)PRIMA12, (A14)PRIMA14,(A15)PRIMA15,(A16)PRIMA16,(A17)PRIMA17, (A18)PRIMA18,(A19)PRIMA19,(A22)PRIMA22 FROM MWTEMP.TEMPTABLE WHERE A22 = $P{START_DATE} ||'_PRIMA_X1' AND ((A01 = $P{STR_DATE} and substr(A02,1,2) >= '23') OR (A01 = $P{END_DATE} and substr(A02,1,2) < '23'))) AS PRIMA ON CORE.CORE01 = PRIMA.PRIMA01 AND CORE.CORE02 = PRIMA.PRIMA02 AND CORE.CORE14= PRIMA.PRIMA14 WHERE((PRIMA.PRIMA19 = 'BERHASIL' AND CORE.CORE14 IS NOT NULL)) AND CORE.CORE03 NOT IN('5146','5147','5148','5149') ORDER BY CORE.CORE01]]>
<band height="30" splitType="Stretch">
<staticText>
<reportElement x="0" y="0" width="2664" height="30"/>
<textElement textAlignment="Center">
<font size="14" isBold="true"/>
</textElement>
<text><![CDATA[PRIMA TRANSFER ISSUER MATCH]]></text>
</staticText>
</band>