APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on QP_SEGMENTS_B

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

1245:
1246: UPDATE qp_pte_segments set used_in_setup='Y'
1247: WHERE nvl(used_in_setup,'N')='N'
1248: AND segment_id IN
1249: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1250: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.pricing_attribute
1251: AND a.prc_context_id=b.prc_context_id
1252: AND b.prc_context_type='PRICING_ATTRIBUTE'
1253: AND b.prc_context_code=p_PRICING_ATTR_rec.pricing_attribute_context);

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

1259:
1260: UPDATE qp_pte_segments set used_in_setup='Y'
1261: WHERE nvl(used_in_setup,'N')='N'
1262: AND segment_id IN
1263: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1264: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute
1265: AND a.prc_context_id=b.prc_context_id
1266: AND b.prc_context_type='PRODUCT'
1267: AND b.prc_context_code=p_PRICING_ATTR_rec.product_attribute_context);

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

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

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

1457:
1458: UPDATE qp_pte_segments set used_in_setup='Y'
1459: WHERE nvl(used_in_setup,'N')='N'
1460: AND segment_id IN
1461: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1462: WHERE a.segment_mapping_column=p_PRICING_ATTR_rec.product_attribute
1463: AND a.prc_context_id=b.prc_context_id
1464: AND b.prc_context_type='PRODUCT'
1465: AND b.prc_context_code=p_PRICING_ATTR_rec.product_attribute_context);