199:
200: IF l_check_active_flag = 'N' THEN
201: IF p_context_type='QUALIFIER' THEN
202: BEGIN
203: SELECT 'Y' INTO x_is_used FROM qp_qualifiers
204: WHERE qualifier_context = p_context_code
205: AND qualifier_attribute = p_attribute_code AND rownum < 2;
206: EXCEPTION
207: WHEN no_data_found THEN
286: END IF;
287: ELSIF l_check_active_flag = 'Y' THEN
288: IF p_context_type='QUALIFIER' THEN
289: BEGIN
290: SELECT 'Y' INTO x_is_used FROM qp_qualifiers
291: WHERE qualifier_context = p_context_code
292: AND qualifier_attribute = p_attribute_code
293: AND active_flag = 'Y' AND rownum < 2;
294: EXCEPTION