APPS.BSC_SIMULATION_VIEW_PVT dependencies on BSC_SYS_DATASETS_B

Line 685: FROM bsc_sys_datasets_b a

681: --now set the default node id for the duplicate objective
682:
683: SELECT a.source ,a.dataset_id
684: INTO l_type ,l_node_id
685: FROM bsc_sys_datasets_b a
686: ,bsc_kpi_properties b
687: WHERE b.property_code = BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID
688: AND b.property_value =a.dataset_id
689: AND indicator =p_source_kpi;

Line 1067: FROM bsc_sys_datasets_b

1063: l_count :=0;
1064:
1065: SELECT COUNT(0)
1066: INTO l_count
1067: FROM bsc_sys_datasets_b
1068: WHERE dataset_id= p_dataset_id
1069: AND color_method =p_color_method;
1070:
1071: UPDATE bsc_sys_datasets_b

Line 1071: UPDATE bsc_sys_datasets_b

1067: FROM bsc_sys_datasets_b
1068: WHERE dataset_id= p_dataset_id
1069: AND color_method =p_color_method;
1070:
1071: UPDATE bsc_sys_datasets_b
1072: SET color_method =p_color_method
1073: WHERE dataset_id = p_dataset_id;
1074:
1075: l_kpi_measure_id := BSC_SIMULATION_VIEW_PUB.Get_Kpi_Measure_Id