[load_grdList]
select
  t.syukin_no
, t.sir_cd
, t.syukin_ymd
, t.syukin_kbn
, t.syukin_gaku
, t.tesuryo
, t.cyosei_gaku
, t.total_gaku
, t.biko
, t.seikyu_flg
, t.seikyu_ymd
, h1.han_name as syukin_kbn_nm
, tk.sir_nm
from t_syukin t
left join m_sir tk on (tk.sir_cd = t.sir_cd)
left join m_hanyo h1 on (h1.mst_kbn = '19' and h1.han_cd = t.syukin_kbn)
where 1 = 1
and t.del_flg = 0
and ((t.syukin_no = fnc_to_number(':den_no')) or ('' = ':den_no'))
and (('' = ':syori_ymd_fr') or (t.syukin_ymd >= ':syori_ymd_fr'))
and (('' = ':syori_ymd_to') or (t.syukin_ymd <= ':syori_ymd_to'))
and (('' = ':sir_cd') or (t.sir_cd = ':sir_cd'))
and ((tk.sir_nm like '%:sir_nm%') or ('' = ':sir_nm'))
and ((t.biko like '%:biko1%') or ('' = ':biko1'))
order by t.syukin_ymd desc, t.syukin_no desc