APPS.BIS_REPORT_PUB SQL Statements

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

Line: 26

select web_html_call,parameters,type
  from fnd_form_functions
 where function_name = cpFunctionName;

Line: 85

SELECT region_application_id FROM ak_regions
WHERE region_code = cp_region_code;

Line: 170

SELECT application_name FROM ak_regions R, fnd_application_vl A
WHERE R.region_code = cp_region_code AND R.region_application_id = A.application_id;

Line: 176

  SELECT application_name
  FROM fnd_application_vl app
  WHERE app.application_short_name = l_code;

Line: 215

SELECT attribute10 FROM ak_regions
WHERE region_code = cp_region_code;

Line: 267

  select dim_group_id into l_dim_group_id
  from bsc_sys_dim_groups_vl
  where short_name = l_dim_group_name;

Line: 271

  select dim_level_id into l_dim_level_id
  from bsc_sys_dim_levels_b
  where short_name = l_dim_level_name;

Line: 275

  select total_flag into l_total_flag
  from bsc_sys_dim_levels_by_group
  where dim_group_id = l_dim_group_id
  and dim_level_id = l_dim_level_id;

Line: 300

  select count(*) into l_count
  from ak_region_items ri, bis_indicators i, bsc_sys_datasets_b d
  where ri.region_code = p_region_code
  and ri.region_application_id = p_region_application_id
  and attribute1 = 'MEASURE_NOTARGET'
  and attribute2 = i.short_name
  and i.dataset_id = d.dataset_id
  and d.source = 'CDS';