DBA Data[Home] [Help]

APPS.BSC_COPY_INDICATOR_PUB dependencies on BSC_SYS_DATASETS_TL

Line 1093: SET name = (SELECT d.name FROM bsc_sys_datasets_tl d WHERE

1089:
1090: IF p_Old_DataSet_Map(i) <> p_New_DataSet_Map(i) AND
1091: BSC_DESIGNER_PVT.g_DbLink_Name IS NULL THEN
1092: UPDATE bsc_kpi_analysis_measures_tl km
1093: SET name = (SELECT d.name FROM bsc_sys_datasets_tl d WHERE
1094: d.dataset_id = p_New_DataSet_Map(i) AND d.language = km.language),
1095: help = (SELECT d.help FROM bsc_sys_datasets_tl d WHERE
1096: d.dataset_id = p_New_DataSet_Map(i) AND d.language = km.language)
1097: WHERE indicator = p_Target_Indicator;

Line 1095: help = (SELECT d.help FROM bsc_sys_datasets_tl d WHERE

1091: BSC_DESIGNER_PVT.g_DbLink_Name IS NULL THEN
1092: UPDATE bsc_kpi_analysis_measures_tl km
1093: SET name = (SELECT d.name FROM bsc_sys_datasets_tl d WHERE
1094: d.dataset_id = p_New_DataSet_Map(i) AND d.language = km.language),
1095: help = (SELECT d.help FROM bsc_sys_datasets_tl d WHERE
1096: d.dataset_id = p_New_DataSet_Map(i) AND d.language = km.language)
1097: WHERE indicator = p_Target_Indicator;
1098: END IF;
1099: EXIT;