SELECT
     CH0391.PRC_GRP_CD
    ,CH0391.PCRS_CD
    ,CH0391.PRC_SVC_CD
    ,CH0391.PRC_KMK_CD
    ,CH0391.PRC_KMK_NM
FROM
    CH_M_PRC_KMK_OPUT_NM CH0391
    INNER JOIN CH_M_PRC_KMK_CS_CHGE CH0401
        ON  CH0401.OUT_PRC_KMK_CD = CH0391.PRC_KMK_CD
    INNER JOIN ZM_M_WORK_PARAM_KNRI ZM0321
        ON  CH0401.WORK_KINO_SKBT_CD = ZM0321.WORK_PARAM_SETTE_VALUE
WHERE
    ZM0321.WORK_PARAM_ID = 'AC_WKS_OT_VCMS_CRIF'
    AND CH0401.SYS_CD = 'AC'
    AND CH0401.CHSHT_CHG_CD = '2'
    AND CH0401.PRC_KMK_CS_CHGE_TSTAYMD <= :OPEDATE
    AND CH0401.PRC_KMK_CS_CHGE_TENDYMD >= :OPEDATE
    AND CH0401.MK_FLG = '0'
    AND ZM0321.MK_FLG = '0'
    AND CH0391.PRC_KMK_NM_SBT_CD = '1'
    AND CH0391.PRC_KMK_OPUT_NM_TSTAYMD <= :OPEDATE
    AND CH0391.PRC_KMK_OPUT_NM_TENDYMD >= :OPEDATE
    AND CH0391.MK_FLG = '0'
ORDER BY CH0391.PRC_GRP_CD, CH0391.PCRS_CD, CH0391.PRC_SVC_CD, CH0391.PRC_KMK_CD