= '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,(A22)PRIMA22 FROM MWTEMP.TEMPTABLE WHERE A22 LIKE $P{START_DATE}||'_PRIMA_R1' 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.PRIMA17 = 'BERHASIL' AND CORE.CORE14 IS NOT NULL)) AND CORE.CORE03 NOT IN('5132','5133')
ORDER BY CORE.CORE01]]>
<band height="30" splitType="Stretch">
<staticText>
<reportElement x="0" y="0" width="2520" height="30"/>
<textElement textAlignment="Center">
<font size="14" isBold="true"/>
</textElement>
<text><![CDATA[PRIMA WITHDRAWAL MATCH]]></text>
</staticText>
</band>