APPS.QP_PRICING_ATTR_UTIL dependencies on QP_SEGMENTS_B

Line 1540: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b

1536:
1537: UPDATE qp_pte_segments set used_in_setup='Y'
1538: WHERE nvl(used_in_setup,'N')='N'
1539: AND segment_id IN
1540: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1541: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute
1542: AND a.prc_context_id=b.prc_context_id
1543: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
1544: AND b.prc_context_code=p_PRICING_ATTR_rec.pricing_attribute_context);

Line 1554: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b

1550:
1551: UPDATE qp_pte_segments set used_in_setup='Y'
1552: WHERE nvl(used_in_setup,'N')='N'
1553: AND segment_id IN
1554: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1555: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute
1556: AND a.prc_context_id=b.prc_context_id
1557: AND b.prc_context_type = 'PRODUCT'
1558: AND b.prc_context_code=p_PRICING_ATTR_rec.product_attribute_context);

Line 1804: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b

1800:
1801: UPDATE qp_pte_segments set used_in_setup='Y'
1802: WHERE nvl(used_in_setup,'N')='N'
1803: AND segment_id IN
1804: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1805: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute
1806: AND a.prc_context_id=b.prc_context_id
1807: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
1808: AND b.prc_context_code=p_PRICING_ATTR_rec.pricing_attribute_context);

Line 1819: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b

1815:
1816: UPDATE qp_pte_segments set used_in_setup='Y'
1817: WHERE nvl(used_in_setup,'N')='N'
1818: AND segment_id IN
1819: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1820: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute
1821: AND a.prc_context_id=b.prc_context_id
1822: AND b.prc_context_type = 'PRODUCT'
1823: AND b.prc_context_code=p_PRICING_ATTR_rec.product_attribute_context);