SELECT
    CH0401.PRC_GRP_CD ,
    CH0401.PCRS_CD,
    CH0401.PRC_SVC_CD,
    CH0401.PRC_KMK_CD
FROM CH_M_PRC_KMK_CS_CHGE CH0401
    INNER JOIN ZM_M_WORK_PARAM_KNRI ZM0321
        ON  CH0401.WORK_KINO_SKBT_CD = ZM0321.WORK_PARAM_SETTE_VALUE
WHERE ZM0321.WORK_PARAM_ID IN ('CH_WKS_MAEUK_JT_SIKY','CH_WKS_JUTO_GOKEI')
AND CH0401.SYS_CD = 'CH'
AND CH0401.CHSHT_CHG_CD = '1'
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'