APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_KPI_ANALYSIS_OPTIONS_VL

Line 3932: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

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
3933: WHERE ANALYSIS_GROUP_ID =0
3934: AND OPTION_ID = p_a0
3935: AND INDICATOR = p_indicator;
3936: ELSIF(l_group_id =1 AND h_ag_count >0) THEN

Line 3943: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

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
3943: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
3944: WHERE ANALYSIS_GROUP_ID = 1
3945: AND OPTION_ID = p_a1
3946: AND INDICATOR = p_indicator;
3947: ELSE

Line 3950: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

3946: AND INDICATOR = p_indicator;
3947: ELSE
3948: BEGIN
3949: SELECT NAME INTO l_anal_name
3950: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
3951: WHERE ANALYSIS_GROUP_ID =1
3952: AND OPTION_ID = p_a1
3953: AND PARENT_OPTION_ID = p_a0
3954: AND INDICATOR = p_indicator;

Line 3975: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

3971: AND INDICATOR = p_indicator;
3972: IF h_ag2_depend = 0 THEN
3973: SELECT NAME
3974: INTO l_anal_name
3975: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
3976: WHERE ANALYSIS_GROUP_ID =2
3977: AND OPTION_ID=p_a2
3978: AND INDICATOR=p_indicator;
3979: ELSE

Line 3984: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

3980: IF h_ag2_depend = 1 AND h_ag1_depend = 0 THEN
3981: BEGIN
3982: SELECT NAME
3983: INTO l_anal_name
3984: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
3985: WHERE ANALYSIS_GROUP_ID = 2
3986: AND OPTION_ID = p_a2
3987: AND PARENT_OPTION_ID = p_a1
3988: AND INDICATOR = p_indicator;

Line 3997: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

3993: ELSE
3994: BEGIN
3995: SELECT NAME
3996: INTO l_anal_name
3997: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
3998: WHERE ANALYSIS_GROUP_ID = 2
3999: AND OPTION_ID = p_a2
4000: AND PARENT_OPTION_ID = p_a1
4001: AND GRANDPARENT_OPTION_ID = p_a0

Line 4618: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

4614: END LOOP;
4615: END IF;
4616:
4617: SELECT COUNT(1) INTO l_namecount
4618: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
4619: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
4620:
4621: SELECT COUNT(1) INTO l_index
4622: FROM BSC_KPI_ANALYSIS_MEASURES_B

Line 5159: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

5155: other wise create a new analysis option.
5156: *********************************************************************************/
5157: SELECT COUNT(0)
5158: INTO l_namecount
5159: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
5160: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5161:
5162: SELECT COUNT(*)
5163: INTO l_index