APPS.BIS_PMV_BSC_API_PVT SQL Statements

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

Line: 59

SELECT region_code FROM ak_region_items WHERE attribute1='MEASURE' AND
    attribute2 = cp_measure_short_name
    ORDER BY creation_date DESC;

Line: 64

  SELECT attribute1 FROM ak_regions
  WHERE region_code = cp_region_code;

Line: 68

   SELECT nested_region_code FROM ak_region_items
   WHERE region_code=cp_region_code AND item_style='NESTED_REGION';

Line: 74

SELECT attribute_code attribute_code, attribute1 attribute_type, attribute2 attribute_value, required_flag
FROM ak_region_items WHERE region_code = cp_region_code AND
 attribute1 IN ('DIM LEVEL SINGLE VALUE', 'DIMENSION LEVEL', 'HIDE DIMENSION LEVEL',
  'HIDE PARAMETER', 'HIDE VIEW BY DIMENSION', 'VIEWBY PARAMETER', 'HIDE_VIEW_BY_DIM_SINGLE');