APPS.QP_PRICE_LIST_LINE_UTIL dependencies on QP_SEGMENTS_B

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

1814:
1815: UPDATE qp_pte_segments set used_in_setup='Y'
1816: WHERE nvl(used_in_setup,'N')='N'
1817: AND segment_id IN
1818: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1819: WHERE a.segment_mapping_column=p_PRICE_LIST_LINE_rec.break_uom_attribute
1820: AND a.prc_context_id=b.prc_context_id
1821: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
1822: AND b.prc_context_code=p_PRICE_LIST_LINE_rec.break_uom_context);

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

2053:
2054: UPDATE qp_pte_segments set used_in_setup='Y'
2055: WHERE nvl(used_in_setup,'N')='N'
2056: AND segment_id IN
2057: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
2058: WHERE a.segment_mapping_column=p_PRICE_LIST_LINE_rec.break_uom_attribute
2059: AND a.prc_context_id=b.prc_context_id
2060: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
2061: AND b.prc_context_code=p_PRICE_LIST_LINE_rec.break_uom_context);

Line 4384: FROM qp_segments_tl a, qp_segments_b b,

4380: CURSOR attribute_cur(a_context_type VARCHAR2, a_context_code VARCHAR2,
4381: a_pte_code VARCHAR2, a_attribute VARCHAR2)
4382: IS
4383: SELECT b.segment_code
4384: FROM qp_segments_tl a, qp_segments_b b,
4385: qp_prc_contexts_b c, qp_pte_segments d
4386: WHERE c.prc_context_type = a_context_type
4387: AND c.prc_context_code = a_context_code
4388: AND c.prc_context_id = b.prc_context_id