APPS.QP_PRICE_LIST_LINE_UTIL dependencies on QP_PRC_CONTEXTS_B

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

1809:
1810: UPDATE qp_pte_segments set used_in_setup='Y'
1811: WHERE nvl(used_in_setup,'N')='N'
1812: AND segment_id IN
1813: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1814: WHERE a.segment_mapping_column=p_PRICE_LIST_LINE_rec.break_uom_attribute
1815: AND a.prc_context_id=b.prc_context_id
1816: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
1817: AND b.prc_context_code=p_PRICE_LIST_LINE_rec.break_uom_context);

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

2048:
2049: UPDATE qp_pte_segments set used_in_setup='Y'
2050: WHERE nvl(used_in_setup,'N')='N'
2051: AND segment_id IN
2052: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
2053: WHERE a.segment_mapping_column=p_PRICE_LIST_LINE_rec.break_uom_attribute
2054: AND a.prc_context_id=b.prc_context_id
2055: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
2056: AND b.prc_context_code=p_PRICE_LIST_LINE_rec.break_uom_context);

Line 4239: qp_prc_contexts_b c, qp_pte_segments d

4235: a_pte_code VARCHAR2, a_attribute VARCHAR2)
4236: IS
4237: SELECT b.segment_code
4238: FROM qp_segments_tl a, qp_segments_b b,
4239: qp_prc_contexts_b c, qp_pte_segments d
4240: WHERE c.prc_context_type = a_context_type
4241: AND c.prc_context_code = a_context_code
4242: AND c.prc_context_id = b.prc_context_id
4243: AND b.segment_mapping_column = a_attribute