DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on DUAL

Line 261: SELECT 'Y' INTO x_is_used FROM dual

257: END;
258: END;
259: ELSIF p_context_type='PRODUCT' THEN
260: BEGIN
261: SELECT 'Y' INTO x_is_used FROM dual
262: where exists(SELECT 'Y'
263: FROM qp_pricing_attributes
264: WHERE product_attribute_context = p_context_code
265: AND product_attribute = p_attribute_code);

Line 322: SELECT 'Y' INTO x_is_used FROM dual

318: END;
319: ELSIF p_context_type='PRICING_ATTRIBUTE' THEN
320: BEGIN
321: --modified query to improve performance.
322: SELECT 'Y' INTO x_is_used FROM dual
323: where exists(SELECT 'Y' FROM qp_pricing_attributes qpa, qp_list_headers_b qph
324: WHERE qpa.pricing_attribute_context = p_context_code
325: AND qpa.pricing_attribute = p_attribute_code
326: AND qpa.list_header_id = qph.list_header_id

Line 361: INTO x_is_used FROM dual

357: END;
358: ELSIF p_context_type='PRODUCT' THEN
359: BEGIN
360: SELECT 'Y'
361: INTO x_is_used FROM dual
362: WHERE exists (SELECT 'Y'
363: FROM qp_pricing_attributes a
364: WHERE product_attribute_context = p_context_code
365: AND product_attribute = p_attribute_code