[Home] [Help]
585: l_node_id BIS_INDICATORS.dataset_id%TYPE;
586:
587: CURSOR c_cust_labels IS
588: SELECT DISTINCT link_id
589: FROM bsc_tab_view_labels_vl
590: WHERE tab_id =BSC_SIMULATION_VIEW_PUB.c_TAB_ID
591: AND tab_view_id = p_source_kpi
592: AND label_type
593: IN ( BSC_CUSTOM_VIEW_UI_WRAPPER.c_type_measure,
605: --if yes then don't need to copy any records
606:
607: SELECT COUNT(0)
608: INTO l_count
609: FROM bsc_tab_view_labels_vl
610: WHERE tab_id =BSC_SIMULATION_VIEW_PUB.c_TAB_ID
611: AND tab_view_id = p_target_kpi;
612:
613: IF( l_count =0 )THEN