APPS.BIS_REGISTRATION_SERVICE_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 35

  select dimLevel.DIMENSION_LEVEL_SHORT_NAME
  into l_dim_level_short_name
  from bisbv_dimension_levels dimLevel
  where dimLevel.DIMENSION_ID = to_number(p_parameter_value2) ;

Line: 40

  SELECT MEASURE_SHORT_NAME
  INTO L_MEASURE_SHORT_NAME
  FROM BISBV_PERFORMANCE_MEASURES
  where MEASURE_ID = to_number(p_parameter_value1);