APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_KPI_ANALYSIS_GROUPS

Line 376: FROM BSC_KPI_ANALYSIS_GROUPS

372: CURSOR c_kpi_anal_group IS
373: SELECT Analysis_Group_Id
374: , Num_Of_Options
375: , Dependency_Flag
376: FROM BSC_KPI_ANALYSIS_GROUPS
377: WHERE Indicator = p_kpi_id
378: ORDER BY Analysis_Group_Id;
379:
380: l_Count NUMBER := 0;

Line 3928: FROM BSC_KPI_ANALYSIS_GROUPS

3924: BEGIN
3925: l_group_id := p_group_id;
3926: SELECT MAX( ANALYSIS_GROUP_ID)
3927: INTO h_ag_count
3928: FROM BSC_KPI_ANALYSIS_GROUPS
3929: WHERE INDICATOR = p_indicator;
3930: IF (l_group_id= 0) THEN
3931: SELECT NAME INTO l_anal_name
3932: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

Line 3938: FROM BSC_KPI_ANALYSIS_GROUPS

3934: AND OPTION_ID = p_a0
3935: AND INDICATOR = p_indicator;
3936: ELSIF(l_group_id =1 AND h_ag_count >0) THEN
3937: SELECT DEPENDENCY_FLAG INTO h_ag_depend
3938: FROM BSC_KPI_ANALYSIS_GROUPS
3939: WHERE ANALYSIS_GROUP_ID =1
3940: AND INDICATOR = p_indicator;
3941: IF h_ag_depend = 0 THEN
3942: SELECT NAME INTO l_anal_name

Line 3963: FROM BSC_KPI_ANALYSIS_GROUPS

3959: END IF;
3960: ELSIF((l_group_id =2 AND h_ag_count >1)) THEN
3961: SELECT DEPENDENCY_FLAG
3962: INTO h_ag1_depend
3963: FROM BSC_KPI_ANALYSIS_GROUPS
3964: WHERE ANALYSIS_GROUP_ID =1
3965: AND INDICATOR = p_indicator;
3966:
3967: SELECT DEPENDENCY_FLAG

Line 3969: FROM BSC_KPI_ANALYSIS_GROUPS

3965: AND INDICATOR = p_indicator;
3966:
3967: SELECT DEPENDENCY_FLAG
3968: INTO h_ag2_depend
3969: FROM BSC_KPI_ANALYSIS_GROUPS
3970: WHERE ANALYSIS_GROUP_ID = 2
3971: AND INDICATOR = p_indicator;
3972: IF h_ag2_depend = 0 THEN
3973: SELECT NAME

Line 7460: FROM BSC_KPI_ANALYSIS_GROUPS

7456: CURSOR c_kpi_anal_group IS
7457: SELECT Analysis_Group_Id
7458: , Num_Of_Options
7459: , Dependency_Flag
7460: FROM BSC_KPI_ANALYSIS_GROUPS
7461: WHERE Indicator = p_kpi_id
7462: ORDER BY Analysis_Group_Id;
7463:
7464: CURSOR c_kpi_ids IS

Line 7588: FROM BSC_KPI_ANALYSIS_GROUPS

7584: /*** Check if the source is PMF then directly call the previous API*/
7585: IF (p_data_source = 'BSC') THEN
7586: SELECT COUNT(0)
7587: INTO l_max_group_count
7588: FROM BSC_KPI_ANALYSIS_GROUPS
7589: WHERE INDICATOR = p_kpi_id;
7590:
7591: l_Anal_Num_Tbl(0) := p_Option_0;
7592: l_Anal_Num_Tbl(1) := p_Option_1;