1240: WHERE id = p_id;
1241:
1242: CURSOR c_cim(p_cle_id IN NUMBER) IS
1243: SELECT id
1244: FROM okc_k_items_v
1245: WHERE cle_id = p_cle_id
1246: AND priced_item_yn = 'Y';
1247:
1248: BEGIN
2117: UOM_CODE,
2118: EXCEPTION_YN,
2119: NUMBER_OF_ITEMS,
2120: PRICED_ITEM_YN
2121: FROM OKC_K_ITEMS_V
2122: WHERE ID = p_cim_id;
2123: BEGIN
2124: OPEN c_cimv_rec;
2125: FETCH c_cimv_rec