SELECT /*+ FULL(CH0101) */
    CH0101.SEIKY_KEI_NO
   ,CH0101.SEIKY_NO
   ,TO_CHAR(CH0101.AMNT)
FROM
    CH_T_SEIKY_UCWK CH0101
    INNER JOIN
        CH_M_PRC_KMK_CS_CHGE CH0401
    ON
        CH0101.PRC_GRP_CD = CH0401.PRC_GRP_CD
    AND CH0101.PCRS_CD    = CH0401.PCRS_CD
    AND CH0101.PRC_SVC_CD = CH0401.PRC_SVC_CD
    AND CH0101.PRC_KMK_CD = CH0401.PRC_KMK_CD
WHERE
    CH0101.SEIKY_YM          = :SEIKY_YM
AND CH0101.MK_FLG            = '0'
AND CH0401.SYS_CD            = :SYS_CD
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_ID
                                AND ZM0321.WORK_PARAM_TSTAYMD <= :OPEDATE
                                AND ZM0321.WORK_PARAM_TENDYMD >= :OPEDATE
                                AND ZM0321.MK_FLG = '0'
                                )
AND CH0401.CHSHT_CHG_CD             = :CHSHT_CHG_CD
AND CH0401.PRC_KMK_CS_CHGE_TSTAYMD <= :OPEDATE
AND CH0401.PRC_KMK_CS_CHGE_TENDYMD >= :OPEDATE
AND CH0401.MK_FLG                   = '0'