APPS.BSC_METADATA_OPTIMIZER_PKG dependencies on BSC_TMP_OPT_UI_KPIS

Line 783: (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id=g_processID)

779: cursor cList IS
780: SELECT KPIS.INDICATOR, KPIS.NAME, KPIS.PROTOTYPE_FLAG , decode(nvl(prop.property_value, 1), 1, 'Summary Tables/MVs', 'Analytical Workspace') impl_type
781: FROM BSC_KPIS_VL KPIS, BSC_KPI_PROPERTIES prop
782: WHERE kpis.INDICATOR IN
783: (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id=g_processID)
784: AND kpis.indicator=prop.indicator(+)
785: and prop.property_code(+) = 'IMPLEMENTATION_TYPE'
786: order by indicator;
787: BEGIN

Line 995: FOR i IN (select indicator from bsc_tmp_opt_ui_kpis where process_id = g_processID) LOOP

991: app_exception.raise_exception;
992: return;
993: END IF;
994: ELSE--selected or inter-related
995: FOR i IN (select indicator from bsc_tmp_opt_ui_kpis where process_id = g_processID) LOOP
996: logProgress('LOCK', 'Locking '||i.indicator);
997: bsc_mo_helper_pkg.writeTmp('LOCKING going to lock objective '||i.indicator, fnd_log.level_statement, true);
998: BSC_LOCKS_PUB.GET_SYSTEM_LOCK (
999: i.indicator, 'OBJECTIVE', 'W', sysdate, -200,BSC_APPS.apps_user_id, -1, x_return_status, x_msg_count, x_msg_data);