APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PRC_CONTEXTS_B

Line 2138: FROM qp_prc_contexts_b

2134: --Check if context is valid
2135: BEGIN
2136: SELECT 1
2137: INTO l_count
2138: FROM qp_prc_contexts_b
2139: WHERE prc_context_code = p_pb_input_lines_tbl(j).context
2140: AND prc_context_type = p_pb_input_lines_tbl(j).attribute_type;
2141: EXCEPTION
2142: WHEN OTHERS THEN

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 3216: FROM qp_prc_contexts_b p, qp_segments_b sb, qp_segments_tl stl

3212: IS
3213: BEGIN
3214: SELECT sb.segment_mapping_column
3215: INTO x_attribute_code
3216: FROM qp_prc_contexts_b p, qp_segments_b sb, qp_segments_tl stl
3217: WHERE p.prc_context_code = p_context_code
3218: AND p.prc_context_type = p_attribute_type
3219: AND sb.prc_context_id = p.prc_context_id
3220: AND stl.segment_id = sb.segment_id

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

3268: BEGIN
3269: -- get segment_code from segment_mapping_column
3270: SELECT segment_code
3271: INTO l_segment_code
3272: FROM qp_prc_contexts_b p, qp_segments_b sb, qp_segments_tl stl
3273: WHERE p.prc_context_code = p_context_code
3274: AND p.prc_context_type = p_attribute_type
3275: AND sb.prc_context_id = p.prc_context_id
3276: AND stl.segment_id = sb.segment_id