294: WHERE short_name = pDimShortName;
295:
296: CURSOR c_dimlvls(p_dim_id IN NUMBER, p_search_string IN VARCHAR2) IS
297: SELECT short_name 298: FROM bis_levels 299: where short_name like p_Search_string AND
300: dimension_id= p_dim_id;
301: l_dim_id NUMBER;
302: l_search_string VARCHAR2(32000);