[load_grdList]
select
  m.tok_cd
, mt.tok_nm
from m_tokui_nyukin m
left join m_tokui mt on (mt.tok_cd = m.tok_cd)
where m.furikomi_nm = fnc_translate_case(':furikomi_nm')
order by tok_cd




[insertRecord]
insert into m_tokui_nyukin (
  tok_cd
, furikomi_nm
, del_flg
, cre_id
, cre_time
, upd_id
, upd_time
)
select
  ':tok_cd'
, fnc_translate_case(':furikomi_nm')
, 0 --del_flg
, ':login_id' --cre_id
, now() --cre_time
, ':login_id' --upd_id
, now() --upd_time
where not exists (
select 1 from m_tokui_nyukin m
where m.furikomi_nm = fnc_translate_case(':furikomi_nm')
and m.tok_cd = ':tok_cd'
)


[deleteList]
delete from m_tokui_nyukin m
where m.furikomi_nm = fnc_translate_case(':furikomi_nm')
and m.tok_cd = ':tok_cd'


