DBA Data[Home] [Help]

APPS.QP_VALIDATE_SEG dependencies on QP_PRICING_ATTRIBUTES

Line 571: from qp_pricing_attributes

567: if is_attribute_used = 'N' then
568: if l_context_code is not null and p_SEG_rec.segment_mapping_column is not null then
569: begin
570: SELECT 'Y' into is_attribute_used
571: from qp_pricing_attributes
572: where product_attribute_context = l_context_code and
573: product_attribute = p_SEG_rec.segment_mapping_column and
574: product_attribute_context is not null and
575: product_attribute is not null and

Line 579: from qp_pricing_attributes

575: product_attribute is not null and
576: rownum =1
577: UNION
578: SELECT 'Y'
579: from qp_pricing_attributes
580: where pricing_attribute_context = l_context_code and
581: pricing_attribute = p_SEG_rec.segment_mapping_column and
582: pricing_attribute_context is not null and
583: pricing_attribute is not null and