DBA Data[Home] [Help]

APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on QP_SEGMENTS_B

Line 1503: FROM qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS , qp_segments_tl SEGMENTS_TL

1499: ELSIF l_price_formula_line_type_code = 'PRA'
1500: THEN
1501: SELECT nvl(SEGMENTS_TL.SEEDED_SEGMENT_NAME,SEGMENTS_TL.USER_SEGMENT_NAME)
1502: INTO l_attribute
1503: FROM qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS , qp_segments_tl SEGMENTS_TL
1504: WHERE pcontexts.prc_context_code = l_pricing_attribute_context
1505: AND segments.segment_mapping_column = l_pricing_attribute
1506: AND segments.prc_context_id = pcontexts.prc_context_id
1507: AND segments.segment_id = segments_tl.segment_id