52: IF l_classification IS NOT NULL THEN
53: l_where_clause := l_where_clause || ' AND email_classification_id IN (:l_classification) ';
54: END IF;
55:
56: IF (FND_PROFILE.DEFINED('BIX_EMAIL_SLVL_GOAL')) THEN
57: begin
58: l_goal := TO_NUMBER(FND_PROFILE.VALUE('BIX_EMAIL_SLVL_GOAL'));
59: exception
60: when others then
54: END IF;
55:
56: IF (FND_PROFILE.DEFINED('BIX_EMAIL_SLVL_GOAL')) THEN
57: begin
58: l_goal := TO_NUMBER(FND_PROFILE.VALUE('BIX_EMAIL_SLVL_GOAL'));
59: exception
60: when others then
61: l_goal:=0;
62: end;