APPS.QP_PRICE_BOOK_UTIL dependencies on QP_PTE_REQUEST_TYPES_B

Line 1664: FROM qp_pte_request_types_b

1660: --Get pte_code for the request_type_code
1661: BEGIN
1662: SELECT pte_code
1663: INTO l_pte_code
1664: FROM qp_pte_request_types_b
1665: WHERE request_type_code = l_request_type_code;
1666: EXCEPTION
1667: WHEN OTHERS THEN
1668: l_pte_code := 'ORDFUL';

Line 2165: qp_pte_segments ps, qp_pte_request_types_b pr

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
2169: AND c.prc_context_type = p_pb_input_lines_tbl(j).attribute_type

Line 4342: from qp_pte_request_types_b

4338: l_pte_code VARCHAR2(30);
4339: BEGIN
4340: select pte_code
4341: into l_pte_code
4342: from qp_pte_request_types_b
4343: where request_type_code = p_request_type_code;
4344: return l_pte_code;
4345: EXCEPTION
4346: when others then