APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_KPI_ANALYSIS_OPTIONS_VL

Line 2721: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

2717:
2718: IF (l_group_id= 0) THEN
2719:
2720: SELECT NAME INTO l_anal_name
2721: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
2722: WHERE ANALYSIS_GROUP_ID =0
2723: AND OPTION_ID = p_a0
2724: AND INDICATOR = p_indicator;
2725: ELSIF(l_group_id =1 AND h_ag_count >0) THEN

Line 2733: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

2729: AND INDICATOR = p_indicator;
2730:
2731: IF h_ag_depend = 0 THEN
2732: SELECT NAME INTO l_anal_name
2733: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
2734: WHERE ANALYSIS_GROUP_ID = 1
2735: AND OPTION_ID = p_a1
2736: AND INDICATOR = p_indicator;
2737: ELSE

Line 2741: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

2737: ELSE
2738:
2739: BEGIN
2740: SELECT NAME INTO l_anal_name
2741: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
2742: WHERE ANALYSIS_GROUP_ID =1
2743: AND OPTION_ID = p_a1
2744: AND PARENT_OPTION_ID = p_a0
2745: AND INDICATOR = p_indicator;

Line 2770: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

2766: IF h_ag2_depend = 0 THEN
2767:
2768: SELECT NAME
2769: INTO l_anal_name
2770: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
2771: WHERE ANALYSIS_GROUP_ID =2
2772: AND OPTION_ID=p_a2
2773: AND INDICATOR=p_indicator;
2774: ELSE

Line 2779: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

2775: IF h_ag2_depend = 1 AND h_ag1_depend = 0 THEN
2776: BEGIN
2777: SELECT NAME
2778: INTO l_anal_name
2779: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
2780: WHERE ANALYSIS_GROUP_ID = 2
2781: AND OPTION_ID = p_a2
2782: AND PARENT_OPTION_ID = p_a1
2783: AND INDICATOR = p_indicator;

Line 2792: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

2788: ELSE
2789: BEGIN
2790: SELECT NAME
2791: INTO l_anal_name
2792: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
2793: WHERE ANALYSIS_GROUP_ID = 2
2794: AND OPTION_ID = p_a2
2795: AND PARENT_OPTION_ID = p_a1
2796: AND GRANDPARENT_OPTION_ID = p_a0