[Home] [Help]
133: select asv.id1,
134: asv.id2,
135: asv.name,
136: asv.description
137: from okx_assets_v asv
138: where asv.name = p_name
139: and asv.id1 = nvl(p_id1,asv.id1)
140: and asv.id2 = nvl(p_id2,asv.id2)
141: order by asv.name
9108: CURSOR asset_csr IS
9109:
9110: SELECT '1'
9111:
9112: from OKX_ASSETS_V OKX_ASSET
9113:
9114: WHERE ID1 = p_id1
9115:
9116: AND ID2 = p_id2;