SELECT code_2, code_3, code_4, code5
    value1, value2
FROM (
    SELECT t.*,
        ROW_NUMBER() OVER (PARTITION BY code_1, code_2, code_3, code_4, code_5 ORDER BY date_col DESC) AS rn
    FROM table_name t
    WHERE
        (
            code_1 IN (SELECT code_1 FROM temp_code)
        )
        AND date_col < l_filter_start_date
        AND (code_2 LIKE l_filter_code2 OR l_filter_code2 = ' ')
        AND (code_3 LIKE l_filter_code3 OR l_filter_code3 = ' ')
        AND (code_4 = l_filter_code4 OR l_filter_code4 = ' ' )
        AND (code_5 = l_filter_code5 OR l_filter_code5 = ' ' )
)
WHERE rn = 1;