= '23') OR (A01 = $P{END_DATE} and substr(A02,1,2) < '23'))) AS CORE FULL JOIN (SELECT A01 ||'-'||A02||'-'||A14 AS COMPID_PRIMA, 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_B1' 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 NULL) OR (PRIMA.PRIMA19 = 'GAGAL' AND CORE.CORE14 IS NOT NULL) OR (PRIMA.PRIMA14 IS NULL AND CORE.CORE14 IS NOT NULL)) AND (PRIMA.COMPID_PRIMA NOT IN(SELECT A01 ||'-'||A02||'-'||A14 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'))) OR (CORE.COMPID_CORE NOT IN(SELECT A01 ||'-'||A02||'-'||A14 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')))))]]>