262: )
263: IS
264:
265: l_actual BISBV_ACTUALS.ACTUAL_VALUE%TYPE;
266: l_target BISBV_TARGETS.TARGET%TYPE;
267: l_range1_low BISBV_TARGETS.RANGE1_LOW%TYPE;
268: l_range1_high BISBV_TARGETS.RANGE1_HIGH%TYPE;
269: l_range2_low BISBV_TARGETS.RANGE2_LOW%TYPE;
270: l_range2_high BISBV_TARGETS.RANGE2_HIGH%TYPE;
263: IS
264:
265: l_actual BISBV_ACTUALS.ACTUAL_VALUE%TYPE;
266: l_target BISBV_TARGETS.TARGET%TYPE;
267: l_range1_low BISBV_TARGETS.RANGE1_LOW%TYPE;
268: l_range1_high BISBV_TARGETS.RANGE1_HIGH%TYPE;
269: l_range2_low BISBV_TARGETS.RANGE2_LOW%TYPE;
270: l_range2_high BISBV_TARGETS.RANGE2_HIGH%TYPE;
271: l_range3_low BISBV_TARGETS.RANGE3_LOW%TYPE;
264:
265: l_actual BISBV_ACTUALS.ACTUAL_VALUE%TYPE;
266: l_target BISBV_TARGETS.TARGET%TYPE;
267: l_range1_low BISBV_TARGETS.RANGE1_LOW%TYPE;
268: l_range1_high BISBV_TARGETS.RANGE1_HIGH%TYPE;
269: l_range2_low BISBV_TARGETS.RANGE2_LOW%TYPE;
270: l_range2_high BISBV_TARGETS.RANGE2_HIGH%TYPE;
271: l_range3_low BISBV_TARGETS.RANGE3_LOW%TYPE;
272: l_range3_high BISBV_TARGETS.RANGE3_HIGH%TYPE;
265: l_actual BISBV_ACTUALS.ACTUAL_VALUE%TYPE;
266: l_target BISBV_TARGETS.TARGET%TYPE;
267: l_range1_low BISBV_TARGETS.RANGE1_LOW%TYPE;
268: l_range1_high BISBV_TARGETS.RANGE1_HIGH%TYPE;
269: l_range2_low BISBV_TARGETS.RANGE2_LOW%TYPE;
270: l_range2_high BISBV_TARGETS.RANGE2_HIGH%TYPE;
271: l_range3_low BISBV_TARGETS.RANGE3_LOW%TYPE;
272: l_range3_high BISBV_TARGETS.RANGE3_HIGH%TYPE;
273: l_comparison_result VARCHAR2(32000);
266: l_target BISBV_TARGETS.TARGET%TYPE;
267: l_range1_low BISBV_TARGETS.RANGE1_LOW%TYPE;
268: l_range1_high BISBV_TARGETS.RANGE1_HIGH%TYPE;
269: l_range2_low BISBV_TARGETS.RANGE2_LOW%TYPE;
270: l_range2_high BISBV_TARGETS.RANGE2_HIGH%TYPE;
271: l_range3_low BISBV_TARGETS.RANGE3_LOW%TYPE;
272: l_range3_high BISBV_TARGETS.RANGE3_HIGH%TYPE;
273: l_comparison_result VARCHAR2(32000);
274:
267: l_range1_low BISBV_TARGETS.RANGE1_LOW%TYPE;
268: l_range1_high BISBV_TARGETS.RANGE1_HIGH%TYPE;
269: l_range2_low BISBV_TARGETS.RANGE2_LOW%TYPE;
270: l_range2_high BISBV_TARGETS.RANGE2_HIGH%TYPE;
271: l_range3_low BISBV_TARGETS.RANGE3_LOW%TYPE;
272: l_range3_high BISBV_TARGETS.RANGE3_HIGH%TYPE;
273: l_comparison_result VARCHAR2(32000);
274:
275: BEGIN
268: l_range1_high BISBV_TARGETS.RANGE1_HIGH%TYPE;
269: l_range2_low BISBV_TARGETS.RANGE2_LOW%TYPE;
270: l_range2_high BISBV_TARGETS.RANGE2_HIGH%TYPE;
271: l_range3_low BISBV_TARGETS.RANGE3_LOW%TYPE;
272: l_range3_high BISBV_TARGETS.RANGE3_HIGH%TYPE;
273: l_comparison_result VARCHAR2(32000);
274:
275: BEGIN
276: