APPS.BSC_SIMULATION_VIEW_PVT dependencies on DUAL

Line 353: INTO l_owner FROM DUAL;

349: BSC_APPS.Init_Bsc_Apps;
350:
351: IF(INSTR(p_table_name,'BIS')>0)THEN
352: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)
353: INTO l_owner FROM DUAL;
354: ELSIF(INSTR(p_table_name,'FND')>0) THEN
355: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
356: INTO l_owner FROM DUAL;
357: ELSE

Line 356: INTO l_owner FROM DUAL;

352: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('BIS'),USER)
353: INTO l_owner FROM DUAL;
354: ELSIF(INSTR(p_table_name,'FND')>0) THEN
355: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
356: INTO l_owner FROM DUAL;
357: ELSE
358: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('AK'),USER)
359: INTO l_owner FROM DUAL;
360: END IF;

Line 359: INTO l_owner FROM DUAL;

355: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('FND'),USER)
356: INTO l_owner FROM DUAL;
357: ELSE
358: SELECT DECODE(USER,BSC_APPS.get_user_schema('APPS'),BSC_APPS.get_user_schema('AK'),USER)
359: INTO l_owner FROM DUAL;
360: END IF;
361:
362:
363: IF(p_Src_kpi IS NOT NULL AND p_Trg_kpi IS NOT NULL) THEN

Line 529: FROM dual;

525: IF(p_table_name='BSC_SYS_IMAGES_MAP_TL' AND UPPER(x_arr_columns(i)) = 'IMAGE_ID') THEN
526:
527: SELECT bsc_sys_image_id_s.nextval
528: INTO l_next_image_id
529: FROM dual;
530: h_sql:= h_sql || l_next_image_id || ' AS ' || x_arr_columns(i);
531: ELSIF(p_table_name='BSC_SYS_IMAGES' AND UPPER(x_arr_columns(i)) = 'IMAGE_ID' )THEN
532:
533: SELECT DISTINCT image_id

Line 976: FROM DUAL;

972: --DECODE(p_color_flag,1,'F','Y')
973:
974: SELECT DECODE(p_color_flag,1,BSC_SIMULATION_VIEW_PVT.C_SHOW_COLOR,BSC_SIMULATION_VIEW_PVT.C_DISABLE_COLOR)
975: INTO l_kpi_measure_rec.disable_color
976: FROM DUAL;
977:
978: l_kpi_measure_rec.objective_id := p_indicator;
979: l_kpi_measure_rec.kpi_measure_id := l_kpi_measure_id;
980: l_kpi_measure_rec.apply_color_flag := 1;

Line 1300: FROM dual;

1296: l_new_region_code := BSC_BIS_KPI_CRUD_PUB.Generate_Unique_Region_Code();
1297:
1298: SELECT FND_FORM_FUNCTIONS_S.NEXTVAL
1299: INTO l_new_function_id
1300: FROM dual;
1301:
1302:
1303: FOR cd IN c_sim_nodes LOOP
1304: BSC_KPI_TREE_NODES_PKG.DELETE_ROW