SELECT
    CH0401_2_SUB.PRC_GRP_CD
   ,CH0401_2_SUB.PCRS_CD
   ,CH0401_2_SUB.PRC_SVC_CD
   ,CH0401_2_SUB.PRC_KMK_CD
   ,CH0401_2_SUB.OUTPUT_PRC_GRP_CD
   ,CH0401_2_SUB.OUT_PCRS_CD
   ,CH0401_2_SUB.OUT_PRC_SVC_CD
   ,CH0401_2_SUB.OUT_PRC_KMK_CD
FROM
    (SELECT
        ZM0321_2_SUB.WORK_PARAM_SETTE_VALUE
    FROM 
        ZM_M_WORK_PARAM_KNRI ZM0321_2_SUB
    WHERE
        ZM0321_2_SUB.WORK_PARAM_ID       = :WORK_PARAM_ID
    AND :OPEDATE BETWEEN ZM0321_2_SUB.WORK_PARAM_TSTAYMD AND ZM0321_2_SUB.WORK_PARAM_TENDYMD
    AND ZM0321_2_SUB.MK_FLG              = '0'
    ) ZM0321_2
   ,CH_M_PRC_KMK_CS_CHGE CH0401_2_SUB
WHERE
    CH0401_2_SUB.SYS_CD            = :SYS_CD
AND CH0401_2_SUB.WORK_KINO_SKBT_CD = ZM0321_2.WORK_PARAM_SETTE_VALUE
AND CH0401_2_SUB.CHSHT_CHG_CD      = :CHSHT_CHG_CD
AND :OPEDATE BETWEEN CH0401_2_SUB.PRC_KMK_CS_CHGE_TSTAYMD AND CH0401_2_SUB.PRC_KMK_CS_CHGE_TENDYMD 
AND CH0401_2_SUB.MK_FLG            = '0'