APPS.BIS_UPDATE_ACTUAL_SOURCE_PVT dependencies on BIS_INDICATORS

Line 11: FROM bis_indicators a, bsc_sys_datasets_b b, ak_region_items ak

7: SELECT a.indicator_id,
8: a.short_name,
9: ak.region_code,
10: ak.attribute_code
11: FROM bis_indicators a, bsc_sys_datasets_b b, ak_region_items ak
12: WHERE a.dataset_id = b.dataset_id
13: AND a.actual_data_source IS NULL
14: AND b.source = 'PMF'
15: AND ak.attribute1 = 'MEASURE'

Line 28: UPDATE bis_indicators SET actual_data_source_type = 'AK'

24: l_actual_data_source := measure_data_source_rec.region_code || '.' || measure_data_source_rec.attribute_code;
25: END IF;
26:
27: IF(l_actual_data_source IS NOT NULL) THEN
28: UPDATE bis_indicators SET actual_data_source_type = 'AK'
29: , actual_data_source = l_actual_data_source
30: WHERE short_name = measure_data_source_rec.short_name;
31: END IF;
32: