SELECT
    AC0281.PCRS_CD
    ,AC0281.PRC_SVC_CD
    ,AC0281.PRC_KMK_CD
    ,TO_CHAR(AC0281.PRC)
FROM
    AC_M_TEGAK_PRC AC0281
INNER JOIN
    (SELECT
          CH0401.PRC_GRP_CD
         ,CH0401.PCRS_CD
         ,CH0401.PRC_SVC_CD
         ,CH0401.PRC_KMK_CD
     FROM
          CH_M_PRC_KMK_CS_CHGE CH0401
     WHERE
             :OPE_DATE BETWEEN CH0401.PRC_KMK_CS_CHGE_TSTAYMD AND CH0401.PRC_KMK_CS_CHGE_TENDYMD
         AND CH0401.WORK_KINO_SKBT_CD = (
                                             SELECT 
                                                ZM0321.WORK_PARAM_SETTE_VALUE
                                             FROM
                                                 ZM_M_WORK_PARAM_KNRI ZM0321
                                             WHERE
                                                 ZM0321.WORK_PARAM_ID = :WORK_PARAM
                                                 AND :OPE_DATE BETWEEN ZM0321.WORK_PARAM_TSTAYMD AND ZM0321.WORK_PARAM_TENDYMD
                                                 AND ZM0321.MK_FLG = '0'
                                        )
         AND CH0401.MK_FLG = '0'
     ) CH0401
ON
        AC0281.PCRS_CD    = CH0401.PCRS_CD
    AND AC0281.PRC_SVC_CD = CH0401.PRC_SVC_CD
    AND AC0281.PRC_KMK_CD = CH0401.PRC_KMK_CD
    AND :USE_END_YMD BETWEEN AC0281.TEGAKPRC_TSTAYMD AND AC0281.TEGAKPRC_TENDYMD
    AND AC0281.MK_FLG = '0'