APPS.QP_PRICE_LIST_UTIL dependencies on QP_PTE_SEGMENTS

Line 693: update qp_pte_segments d set used_in_setup='Y'

689:
690: -- Dynamic sourcing of attributes changes
691: IF p_PRICE_LIST_rec.active_flag = 'Y'
692: THEN
693: update qp_pte_segments d set used_in_setup='Y'
694: where nvl(used_in_setup,'N')='N'
695: and exists
696: (select 'x'
697: from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c

Line 705: update qp_pte_segments d set used_in_setup='Y'

701: and a.prc_context_id = b.prc_context_id
702: and b.prc_context_type = 'QUALIFIER'
703: and b.prc_context_code = c.qualifier_context);
704:
705: update qp_pte_segments d set used_in_setup='Y'
706: where nvl(used_in_setup,'N')='N'
707: and exists
708: (select 'x'
709: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c

Line 717: update qp_pte_segments d set used_in_setup='Y'

713: and a.prc_context_id = b.prc_context_id
714: and b.prc_context_type = 'PRICING_ATTRIBUTE'
715: and b.prc_context_code = c.pricing_attribute_context);
716:
717: update qp_pte_segments d set used_in_setup='Y'
718: where nvl(used_in_setup,'N')='N'
719: and exists
720: (select 'x'
721: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c