50: ORDER BY idi_type, datetime_valid
51: FOR UPDATE;
52:
53:
54: CURSOR idx_csr(v_name okl_indices_v.name%TYPE,
55: v_idx_type OKL_INDICES_V.idx_type%TYPE) IS
56: SELECT name,
57: id
58: FROM okl_indices_v
51: FOR UPDATE;
52:
53:
54: CURSOR idx_csr(v_name okl_indices_v.name%TYPE,
55: v_idx_type OKL_INDICES_V.idx_type%TYPE) IS
56: SELECT name,
57: id
58: FROM okl_indices_v
59: WHERE name = v_name
54: CURSOR idx_csr(v_name okl_indices_v.name%TYPE,
55: v_idx_type OKL_INDICES_V.idx_type%TYPE) IS
56: SELECT name,
57: id
58: FROM okl_indices_v
59: WHERE name = v_name
60: AND idx_type = v_idx_type;
61:
62: