= '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 NULL ) OR (PRIMA.PRIMA17 = 'GAGAL' AND CORE.CORE14 IS NOT NULL) OR (PRIMA.PRIMA14 IS NULL AND CORE.CORE14 IS NOT NULL))
AND (CORE.CORE03 NOT IN('5132','5133') OR (PRIMA.PRIMA03 = '10')) ORDER BY CORE.CORE02]]>
<band height="30" splitType="Stretch">
<staticText>
<reportElement x="0" y="0" width="2520" height="30"/>
<box>
<rightPen lineWidth="1.0"/>
</box>
<textElement textAlignment="Center">
<font size="14" isBold="true"/>
</textElement>
<text><![CDATA[PRIMA WITHDRAWAL]]></text>
</staticText>
</band>