APPS.BSC_SIMULATION_VIEW_PVT dependencies on BSC_KPI_PROPERTIES

Line 13: FROM bsc_kpi_properties

9: BEGIN
10:
11: SELECT property_value
12: INTO l_node_id
13: FROM bsc_kpi_properties
14: WHERE indicator = p_indicator
15: AND property_code = BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
16:
17: RETURN l_node_id;

Line 686: ,bsc_kpi_properties b

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;
690:

Line 1051: FROM bsc_kpi_properties

1047: )IS
1048:
1049: CURSOR c_def_node IS
1050: SELECT property_value
1051: FROM bsc_kpi_properties
1052: WHERE indicator =p_indicator
1053: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
1054:
1055: l_count NUMBER;

Line 1173: FROM bsc_kpi_properties

1169: BEGIN
1170: IF(p_default_node=1) THEN
1171: SELECT COUNT(0)
1172: INTO l_count
1173: FROM bsc_kpi_properties
1174: WHERE indicator = p_indicator
1175: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
1176:
1177: IF(l_count =0)THEN

Line 1179: INSERT INTO bsc_kpi_properties

1175: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
1176:
1177: IF(l_count =0)THEN
1178: -- INSERT DEFAULT NODE
1179: INSERT INTO bsc_kpi_properties
1180: ( indicator
1181: , property_code
1182: , property_value
1183: , secondary_value

Line 1193: FROM bsc_kpi_properties

1189: );
1190: ELSE
1191: SELECT property_value
1192: INTO l_prev_default_node
1193: FROM bsc_kpi_properties
1194: WHERE indicator =p_indicator
1195: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
1196:
1197: IF(l_prev_default_node <> p_dataset_id) THEN

Line 1198: UPDATE bsc_kpi_properties

1194: WHERE indicator =p_indicator
1195: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
1196:
1197: IF(l_prev_default_node <> p_dataset_id) THEN
1198: UPDATE bsc_kpi_properties
1199: SET property_value = p_dataset_id
1200: WHERE indicator =p_indicator
1201: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
1202: