DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on QP_SEGMENTS_B

Line 2164: FROM qp_segments_b s, qp_prc_contexts_b c,

2160: --Check if attribute is valid
2161: BEGIN
2162: SELECT 1, nvl(user_valueset_id, seeded_valueset_id)
2163: INTO l_count, l_valueset_id
2164: FROM qp_segments_b s, qp_prc_contexts_b c,
2165: qp_pte_segments ps, qp_pte_request_types_b pr
2166: WHERE s.segment_mapping_column = p_pb_input_lines_tbl(j).attribute
2167: AND s.prc_context_id = c.prc_context_id
2168: AND c.prc_context_code = p_pb_input_lines_tbl(j).context

Line 3249: FROM qp_prc_contexts_b p, qp_segments_b sb, qp_segments_tl stl

3245: IS
3246: BEGIN
3247: SELECT sb.segment_mapping_column
3248: INTO x_attribute_code
3249: FROM qp_prc_contexts_b p, qp_segments_b sb, qp_segments_tl stl
3250: WHERE p.prc_context_code = p_context_code
3251: AND p.prc_context_type = p_attribute_type
3252: AND sb.prc_context_id = p.prc_context_id
3253: AND stl.segment_id = sb.segment_id

Line 3305: FROM qp_prc_contexts_b p, qp_segments_b sb, qp_segments_tl stl

3301: BEGIN
3302: -- get segment_code from segment_mapping_column
3303: SELECT segment_code
3304: INTO l_segment_code
3305: FROM qp_prc_contexts_b p, qp_segments_b sb, qp_segments_tl stl
3306: WHERE p.prc_context_code = p_context_code
3307: AND p.prc_context_type = p_attribute_type
3308: AND sb.prc_context_id = p.prc_context_id
3309: AND stl.segment_id = sb.segment_id