APPS.BSC_KPI_PVT dependencies on AK_REGIONS

Line 5424: -- data from ak_regions and tab_view_labels also

5420: ,0
5421: ,'');
5422:
5423: --For Simulation type of objectives we need to copy
5424: -- data from ak_regions and tab_view_labels also
5425: SELECT config_type,short_name
5426: INTO l_config_type,l_short_name
5427: FROM bsc_kpis_vl
5428: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;

Line 7919: --Here delete from ak_Regions also

7915: END LOOP;
7916:
7917:
7918:
7919: --Here delete from ak_Regions also
7920: --first we check if there exists any record in ak_Region then we will delete from the following tables
7921: SELECT COUNT(0)
7922: INTO l_count
7923: FROM ak_regions

Line 7923: FROM ak_regions

7919: --Here delete from ak_Regions also
7920: --first we check if there exists any record in ak_Region then we will delete from the following tables
7921: SELECT COUNT(0)
7922: INTO l_count
7923: FROM ak_regions
7924: WHERE region_code =l_short_name;
7925:
7926:
7927: IF(l_count>0)THEN