[load_grdList]
select m.tok_cd, m.nonyu_no, m.nonyu_nm, m.nonyu_kana, m.zip_no, m.addr1, m.addr2, 
	m.addr3, m.addr4, m.tel_no, m.fax_no, m.nonyu_tan
	, tok.tok_nm
from m_nonyu m
inner join m_tokui tok on m.tok_cd = tok.tok_cd
where ((m.tok_cd = ':tok_cd') or ('' = ':tok_cd'))
AND ((fnc_translate_case(m.nonyu_nm) LIKE '%'||fnc_translate_case(':nonyu_nm')||'%') or (':nonyu_nm' = ''))
AND ((fnc_translate_case(m.addr1) LIKE '%'||fnc_translate_case(':addr1')||'%') or (':addr1' = ''))
AND ((fnc_translate_case(m.tel_no) LIKE '%'||fnc_translate_case(':tel_no')||'%') or (':tel_no' = ''))
order by nonyu_no

[updateDelFlg]
update m_hanyo set
	del_flg = 1
	,upd_id = ':id_user'
	,upd_time = now()
where mst_kbn = ':mst_kbn'
and han_cd = ':han_cd'
;
