APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on QP_PRC_CONTEXTS_B

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

1229:
1230: UPDATE qp_pte_segments set used_in_setup='Y'
1231: WHERE nvl(used_in_setup,'N')='N'
1232: AND segment_id IN
1233: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1234: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute
1235: AND a.prc_context_id=b.prc_context_id
1236: AND b.prc_context_type='PRICING_ATTRIBUTE'
1237: AND b.prc_context_code=p_PRICING_ATTR_rec.pricing_attribute_context);

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

1243:
1244: UPDATE qp_pte_segments set used_in_setup='Y'
1245: WHERE nvl(used_in_setup,'N')='N'
1246: AND segment_id IN
1247: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1248: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute
1249: AND a.prc_context_id=b.prc_context_id
1250: AND b.prc_context_type='PRODUCT'
1251: AND b.prc_context_code=p_PRICING_ATTR_rec.product_attribute_context);

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

1426:
1427: UPDATE qp_pte_segments set used_in_setup='Y'
1428: WHERE nvl(used_in_setup,'N')='N'
1429: AND segment_id IN
1430: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1431: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute
1432: AND a.prc_context_id=b.prc_context_id
1433: AND b.prc_context_type='PRICING_ATTRIBUTE'
1434: AND b.prc_context_code=p_PRICING_ATTR_rec.pricing_attribute_context);

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

1441:
1442: UPDATE qp_pte_segments set used_in_setup='Y'
1443: WHERE nvl(used_in_setup,'N')='N'
1444: AND segment_id IN
1445: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1446: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute
1447: AND a.prc_context_id=b.prc_context_id
1448: AND b.prc_context_type='PRODUCT'
1449: AND b.prc_context_code=p_PRICING_ATTR_rec.product_attribute_context);