BEGIN
    FOR accountnames IN (
        SELECT
            UPPER(BRUGERE)
        FROM
            tmp_StatCPRBunker
        ORDER BY
            UPPER(BRUGERE) DESC
            )

LOOP
-- Bunke_ID 2405
-- SELECT STATEMEN STARTS HERE
SELECT COUNT(*) AS "Antal sager" FROM SAGER SAGER
LEFT JOIN SAGSTYPER SAGSTYPER ON SAGER.SAGSTYPE_ID = SAGSTYPER.SAGSTYPE_ID
LEFT JOIN PERSONER p ON sager.individ_id = p.individ_id
LEFT JOIN kunde.bunkecpr b ON b.cpr = SUBSTR(p.cprnr,1,2)
LEFT JOIN akasseenheder ae ON b.afdeling = ae.navn
LEFT JOIN individ_afdelinger a ON a.akasse_afdeling = ae.individ_id
WHERE 1=1
AND p.individ_id = a.individ_id
AND sagstyper.sagstype IN ('AJA','Samkøring')
AND sager.sagsstatus = 'Aaben'
AND
    (EXISTS (SELECT 1 FROM arbejdsgange a, arbejdsgangstyper_v av, sager s
    WHERE sager.individ_id = s.individ_id
    AND s.sags_id = a.sags_id
    AND a.arbejdsgangstype_id = av.arbejdsgangstype_id
    AND av.navn = 'Indsigelse'
    AND a.internstatus IN ('Aktiv','Ikke startet')
    AND EXISTS (SELECT 1 FROM ydelseskort y
        WHERE y.individ_id = s.individ_id
        AND y.udbetalingstype = 'DP'
        AND y.tildato = (SELECT MAX(y1.tildato) FROM ydelseskort y1 WHERE y1.individ_id = y.individ_id AND y1.status != 'ANN')))
OR
    EXISTS (SELECT 1 FROM ydelseskort yk, ydelseskort_status ys
    WHERE yk.individ_id = sager.individ_id
    AND yk.ydelseskort_id = ys.ydelseskort_id
    AND yk.regulerings_id = ys.regulerings_id
    AND yk.udbetalingstype = 'DP'
    AND yk.status != 'ANN'
    AND ys.status_kode = 'EJOK_OBJ'
    AND ys.sekvensnr = (SELECT MAX(ys2.sekvensnr) FROM ydelseskort_status ys2 WHERE ys.ydelseskort_id=ys2.ydelseskort_id)))
AND b.brugernavn = accountnames
-- SELECT STATEMEN ENDS HERE
END LOOP;
END;