APPS.BIS_MEASURE_VALIDATE_PVT SQL Statements

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

Line: 42

  select 1
  from   bisbv_dimensions
  where  dimension_id = p_dimension_id;

Line: 113

  SELECT 1
  FROM   fnd_lookups
  WHERE  lookup_code = p_actual_data_source_type
  AND    lookup_type = 'BIS_ACTUAL_DATA_SOURCE_TYPE';

Line: 177

  SELECT 1
  FROM   ak_region_items
  WHERE  region_code = SUBSTR(p_actual_data_source, 1,
                              (INSTR(p_actual_data_source, '.', 1)-1)
                             )
--  AND    item_name   = SUBSTR(p_actual_data_source,
  AND    attribute_code   = SUBSTR(p_actual_data_source,
                              (INSTR(p_actual_data_source, '.', 1)+1)
                             );

Line: 245

  SELECT 1
  FROM   fnd_form_functions
  WHERE  function_name = p_function_name;

Line: 308

  SELECT 1
  FROM   ak_region_items
  WHERE  region_code = SUBSTR(p_comparison_source, 1,
                              (INSTR(p_comparison_source, '.', 1)-1)
                             )
--  AND    item_name   = SUBSTR(p_comparison_source,
  AND    attribute_code   = SUBSTR(p_comparison_source,
                              (INSTR(p_comparison_source, '.', 1)+1)
                             );

Line: 376

  SELECT 1
  FROM   fnd_lookups
  WHERE  lookup_code = p_increase_in_measure
  AND    lookup_type = 'BIS_INCREASE_IN_MEASURE';

Line: 441

  SELECT 1
  FROM   fnd_lookups
  WHERE  lookup_code = p_Enable_Link
  AND    lookup_type = 'BIS_PMF_ENABLE_LINK';