[load_grdList]
SELECT 
  h.den_no
, h.syori_ymd
--, h.henpin_flg
, (case when(h.henpin_flg = 1)then('•Ô•i')else('')end) as henpin_flg
, h.prc_sts
, h1.han_name as prc_sts_nm
, h.sir_cd
, h.sir_nm
, h.zeinuki_gaku
, h.zeikomi_gaku
, h.biko1
, h.biko2
, (case when(h.zaiko_flg = 1)then('“ü‰×')else('')end) as nyuka_flg
, (case when(h.keshi_flg = 1)then(to_char(to_date(h.keshi_ymd,'yyyymmdd'),'mm/dd'))else(null)end) as syukin_md
, h.seikyu_flg
, h.keshi_flg
, coalesce(m1.tori_kbn,'0') as tori_kbn
, h2.han_name as eig_nm
FROM t_sir h
left join m_sir m1 on (h.sir_cd = m1.sir_cd)
left join m_hanyo h1 on (h1.mst_kbn = '11' and h1.han_cd = h.prc_sts)
left join m_hanyo h2 on (h2.mst_kbn = '79' and h2.han_cd = h.eig_cd)
WHERE 1 = 1
and h.del_flg = 0
and h.hacyu_flg = 0
and h.syori_ymd != ''
and ((h.den_no = fnc_to_number(':den_no')) or ('' = ':den_no'))
and (('' = ':syori_ymd_fr') or (h.syori_ymd >= ':syori_ymd_fr'))
and (('' = ':syori_ymd_to') or (h.syori_ymd <= ':syori_ymd_to'))
and (('' = ':prc_sts') or (h.prc_sts = ':prc_sts'))
and (('' = ':sir_cd') or (h.sir_cd = ':sir_cd'))
AND ((fnc_translate_case(m1.sir_nm) LIKE '%'||fnc_translate_case(':sir_nm')||'%') or (fnc_translate_case(m1.sir_kana) LIKE '%'||fnc_translate_case(':sir_nm')||'%') or (fnc_translate_case(h.sir_nm) LIKE '%'||fnc_translate_case(':sir_nm')||'%') or (':sir_nm' = ''))
--and ((m1.sir_nm like '%:sir_nm%') or ('' = ':sir_nm'))
and ((h.biko1 like '%:biko1%' or h.biko2 like '%:biko1%') or ('' = ':biko1'))
and (('' = ':tori_kbn') or (m1.sir_cd is not null and m1.tori_kbn = ':tori_kbn'))
and ((':nk_cond' != '0') or (h.keshi_flg = 0))
and ((':nk_cond' != '1') or (h.keshi_flg = 1))
and (('' = ':eig_cd') or (h.eig_cd = ':eig_cd'))
order by h.syori_ymd desc, h.den_no desc

[getSyukin]
select syukin_no as w_syukin_no
from t_syu_keshi
where sir_no = :w_upd_key_value
and keshi_kind = 1