739:
740: -- Dynamic sourcing of attributes changes
741: IF p_PRICE_LIST_rec.active_flag = 'Y'
742: THEN
743: update qp_pte_segments d set used_in_setup='Y'
744: where nvl(used_in_setup,'N')='N'
745: and exists
746: (select 'x'
747: from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c
751: and a.prc_context_id = b.prc_context_id
752: and b.prc_context_type = 'QUALIFIER'
753: and b.prc_context_code = c.qualifier_context);
754:
755: update qp_pte_segments d set used_in_setup='Y'
756: where nvl(used_in_setup,'N')='N'
757: and exists
758: (select 'x'
759: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
763: and a.prc_context_id = b.prc_context_id
764: and b.prc_context_type = 'PRICING_ATTRIBUTE'
765: and b.prc_context_code = c.pricing_attribute_context);
766:
767: update qp_pte_segments d set used_in_setup='Y'
768: where nvl(used_in_setup,'N')='N'
769: and exists
770: (select 'x'
771: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c