APPS.QP_PRICING_ATTR_UTIL dependencies on QP_PRC_CONTEXTS_B

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

1520:
1521: UPDATE qp_pte_segments set used_in_setup='Y'
1522: WHERE nvl(used_in_setup,'N')='N'
1523: AND segment_id IN
1524: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1525: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute
1526: AND a.prc_context_id=b.prc_context_id
1527: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
1528: AND b.prc_context_code=p_PRICING_ATTR_rec.pricing_attribute_context);

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

1534:
1535: UPDATE qp_pte_segments set used_in_setup='Y'
1536: WHERE nvl(used_in_setup,'N')='N'
1537: AND segment_id IN
1538: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1539: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute
1540: AND a.prc_context_id=b.prc_context_id
1541: AND b.prc_context_type = 'PRODUCT'
1542: AND b.prc_context_code=p_PRICING_ATTR_rec.product_attribute_context);

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

1784:
1785: UPDATE qp_pte_segments set used_in_setup='Y'
1786: WHERE nvl(used_in_setup,'N')='N'
1787: AND segment_id IN
1788: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1789: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute
1790: AND a.prc_context_id=b.prc_context_id
1791: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
1792: AND b.prc_context_code=p_PRICING_ATTR_rec.pricing_attribute_context);

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

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