AWS Redshift - correlated query

The below correlated query in redshift returns data at times and the result set is blank sometimes.. is there something wrong with this?

select * from (
    SELECT
        L1.ID AS ID,
        L1.DNZ_CHR_ID,
        L1.LAST_UPDATE_DATE
    FROM
        RSDW_STG_LBV.STG_EBS_OKC_K_LINES_B_CURR L1
    WHERE
        (LSE_ID = 1
        OR LSE_ID = 14
        OR LSE_ID = 19)
        AND L1.ID <= (
        SELECT
            MIN(L2.ID)
        FROM
            RSDW_STG_LBV.STG_EBS_OKC_K_LINES_B_CURR L2
        WHERE 
        (LSE_ID = 1
            OR LSE_ID = 14
            OR LSE_ID = 19) AND 
            L1.DNZ_CHR_ID = L2.DNZ_CHR_ID
            )) a where  DNZ_CHR_ID=693729

I have translated the below oracle correlated query into redshift query.. and here goes the original one and works perfectly fine on oracle.

select * from (
    SELECT
        L1.ID AS ID,
        L1.DNZ_CHR_ID,
        L1.LAST_UPDATE_DATE
    FROM
        LINES_B L1
    WHERE
        (LSE_ID = 1
        OR LSE_ID = 14
        OR LSE_ID = 19)
        AND L1.ID <= ALL (
        SELECT
            L2.ID
        FROM
            LINES_B L2
        WHERE 
        (LSE_ID = 1
            OR LSE_ID = 14
            OR LSE_ID = 19) AND 
            L1.DNZ_CHR_ID = L2.DNZ_CHR_ID
            )) a where  DNZ_CHR_ID=693729