APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_KPI_ANALYSIS_GROUPS

Line 2715: FROM BSC_KPI_ANALYSIS_GROUPS

2711: l_group_id := p_group_id;
2712:
2713: SELECT MAX( ANALYSIS_GROUP_ID)
2714: INTO h_ag_count
2715: FROM BSC_KPI_ANALYSIS_GROUPS
2716: WHERE INDICATOR = p_indicator;
2717:
2718: IF (l_group_id= 0) THEN
2719:

Line 2727: FROM BSC_KPI_ANALYSIS_GROUPS

2723: AND OPTION_ID = p_a0
2724: AND INDICATOR = p_indicator;
2725: ELSIF(l_group_id =1 AND h_ag_count >0) THEN
2726: SELECT DEPENDENCY_FLAG INTO h_ag_depend
2727: FROM BSC_KPI_ANALYSIS_GROUPS
2728: WHERE ANALYSIS_GROUP_ID =1
2729: AND INDICATOR = p_indicator;
2730:
2731: IF h_ag_depend = 0 THEN

Line 2756: FROM BSC_KPI_ANALYSIS_GROUPS

2752: ELSIF((l_group_id =2 AND h_ag_count >1)) THEN
2753:
2754: SELECT DEPENDENCY_FLAG
2755: INTO h_ag1_depend
2756: FROM BSC_KPI_ANALYSIS_GROUPS
2757: WHERE ANALYSIS_GROUP_ID =1
2758: AND INDICATOR = p_indicator;
2759:
2760: SELECT DEPENDENCY_FLAG

Line 2762: FROM BSC_KPI_ANALYSIS_GROUPS

2758: AND INDICATOR = p_indicator;
2759:
2760: SELECT DEPENDENCY_FLAG
2761: INTO h_ag2_depend
2762: FROM BSC_KPI_ANALYSIS_GROUPS
2763: WHERE ANALYSIS_GROUP_ID = 2
2764: AND INDICATOR = p_indicator;
2765:
2766: IF h_ag2_depend = 0 THEN