SELECT
     KK0321.KAKINS_NO
    ,KK0321.SEIKY_KEI_NO
    ,KK0321.SVC_KEI_NO
    , (
        SELECT
            KK0211.PSN
         FROM
            KK_T_SVKEIUW_EO64AIR KK0211
         WHERE
            KK0321.SVC_KEI_UCWK_NO = KK0211.SVC_KEI_UCWK_NO
            AND KK0211.GENE_ADD_DTM =
                (
                    SELECT
                        MAX(KK0211_GENE.GENE_ADD_DTM) AS KK0211_MAX
                    FROM
                        KK_T_SVKEIUW_EO64AIR KK0211_GENE
                    WHERE 
                        KK0211_GENE.SVC_KEI_UCWK_NO = KK0211.SVC_KEI_UCWK_NO
                        AND KK0211_GENE.RSV_APLY_CD = '2'
                        AND KK0211_GENE.MK_FLG = '0'
                )
    ) PSN
FROM
    KK_T_KAKINS KK0321
WHERE
    KK0321.KAKINS_TSTAYMD <= :OPEDATE
    AND KK0321.KAKINS_TENDYMD >= :OPEDATE
    AND KK0321.MK_FLG = '0'