DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on QP_QUALIFIERS

Line 203: SELECT 'Y' INTO x_is_used FROM qp_qualifiers

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

Line 290: SELECT 'Y' INTO x_is_used FROM qp_qualifiers

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