APPS.BSC_OAF_VIEWS_PVT dependencies on BSC_KPI_ANALYSIS_OPTIONS_VL

Line 82: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

78: l_al_count := 0;
79: -- Get Name for A0
80: SELECT NAME
81: INTO h_a0_name
82: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
83: WHERE ANALYSIS_GROUP_ID =0 AND
84: OPTION_ID=X_A0 AND
85: INDICATOR=X_INDICATOR;
86:

Line 106: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

102: IF h_ag1_depend = 0 THEN
103: h_err := 3;
104: SELECT NAME
105: INTO h_a1_name
106: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
107: WHERE ANALYSIS_GROUP_ID =1 AND
108: OPTION_ID=X_A1 AND
109: INDICATOR=X_INDICATOR;
110: ELSE

Line 115: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

111: h_err := 4;
112: BEGIN
113: SELECT NAME
114: INTO h_a1_name
115: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
116: WHERE ANALYSIS_GROUP_ID =1 AND
117: OPTION_ID=X_A1 AND
118: PARENT_OPTION_ID = X_A0 AND
119: INDICATOR=X_INDICATOR;

Line 124: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

120:
121: ---Added to fix the bug 2663355 ----
122: SELECT COUNT(*)
123: INTO l_al_count
124: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
125: WHERE ANALYSIS_GROUP_ID =1 AND
126: PARENT_OPTION_ID = X_A0 AND
127: INDICATOR =X_INDICATOR;
128: ------------------------------------

Line 170: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

166: IF h_ag2_depend = 0 THEN
167: h_err := 7;
168: SELECT NAME
169: INTO h_a2_name
170: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
171: WHERE ANALYSIS_GROUP_ID =2 AND
172: OPTION_ID=X_A2 AND
173: INDICATOR=X_INDICATOR;
174: ELSE

Line 182: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

178: h_err := 9;
179: BEGIN
180: SELECT NAME
181: INTO h_a2_name
182: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
183: WHERE ANALYSIS_GROUP_ID =2 AND
184: OPTION_ID=X_A2 AND
185: PARENT_OPTION_ID = X_A1 AND
186: INDICATOR=X_INDICATOR;

Line 192: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

188:
189: ---Added to fix the bug 2663355 ----
190: SELECT COUNT(*)
191: INTO l_al_count
192: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
193: WHERE ANALYSIS_GROUP_ID =2 AND
194: PARENT_OPTION_ID = X_A1 AND
195: INDICATOR =X_INDICATOR;
196: ------------------------------------

Line 206: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

202: h_err := 10;
203: BEGIN
204: SELECT NAME
205: INTO h_a2_name
206: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
207: WHERE ANALYSIS_GROUP_ID =2 AND
208: OPTION_ID=X_A2 AND
209: PARENT_OPTION_ID = X_A1 AND
210: GRANDPARENT_OPTION_ID = X_A0 AND

Line 216: FROM BSC_KPI_ANALYSIS_OPTIONS_VL

212:
213: -- Added to fix the bug 2663355 ----------
214: SELECT COUNT(*)
215: INTO l_al_count
216: FROM BSC_KPI_ANALYSIS_OPTIONS_VL
217: WHERE ANALYSIS_GROUP_ID =2 AND
218: PARENT_OPTION_ID = X_A1 AND
219: GRANDPARENT_OPTION_ID = X_A0 AND
220: INDICATOR =X_INDICATOR;

Line 456: from BSC_KPI_ANALYSIS_OPTIONS_VL

452:
453: -- Get Name for A0
454: select user_level1
455: into l_disp_flag0
456: from BSC_KPI_ANALYSIS_OPTIONS_VL
457: where analysis_group_id = 0
458: and option_id = x_a0
459: and indicator = x_indicator;
460:

Line 484: from BSC_KPI_ANALYSIS_OPTIONS_VL

480:
481: h_err := 3;
482: select user_level1
483: into l_disp_flag1
484: from BSC_KPI_ANALYSIS_OPTIONS_VL
485: where analysis_group_id = 1
486: and option_id = x_a1
487: and indicator = x_indicator;
488:

Line 501: from BSC_KPI_ANALYSIS_OPTIONS_VL

497: begin
498:
499: select user_level1
500: into l_disp_flag1
501: from BSC_KPI_ANALYSIS_OPTIONS_VL
502: where analysis_group_id = 1
503: and option_id = x_a1
504: and parent_option_id = x_a0
505: and indicator = x_indicator;

Line 543: from BSC_KPI_ANALYSIS_OPTIONS_VL

539:
540: h_err := 7;
541: select user_level1
542: into l_disp_flag2
543: from BSC_KPI_ANALYSIS_OPTIONS_VL
544: where analysis_group_id = 2
545: and option_id = x_a2
546: and indicator = x_indicator;
547:

Line 562: from BSC_KPI_ANALYSIS_OPTIONS_VL

558: h_err := 9;
559: begin
560: select user_level1
561: into l_disp_flag2
562: from BSC_KPI_ANALYSIS_OPTIONS_VL
563: where analysis_group_id = 2
564: and option_id = x_a2
565: and parent_option_id = x_a1
566: and indicator=x_indicator;

Line 585: from BSC_KPI_ANALYSIS_OPTIONS_VL

581: begin
582:
583: select user_level1
584: into l_disp_flag2
585: from BSC_KPI_ANALYSIS_OPTIONS_VL
586: where analysis_group_id = 2
587: and option_id = x_a2
588: and parent_option_id = x_a1
589: and grandparent_option_id = x_a0