APPS.QP_PRICE_BOOK_PVT dependencies on QP_PB_INPUT_LINES

Line 386: FROM qp_pb_input_lines l

382: null, null, --qualifier_type, product_uom_code
383: null, null, --excluder_flag, pricing_phase_id
384: null, null, --incompatibility_grp_code, line_detail_type_code
385: null, null --modifier_level_code, primary_uom_flag
386: FROM qp_pb_input_lines l
387: WHERE pb_input_header_id = a_pb_input_header_id
388: AND EXISTS (SELECT 'x'
389: FROM qp_pte_segments qppseg, qp_prc_contexts_b qpcon,
390: qp_segments_b qpseg, qp_pte_request_types_b qpreq

Line 1887: DELETE FROM qp_pb_input_lines

1883:
1884: DELETE FROM qp_pb_input_headers_tl
1885: WHERE pb_input_header_id = l_old_input_header_id;
1886:
1887: DELETE FROM qp_pb_input_lines
1888: WHERE pb_input_header_id = l_old_input_header_id;
1889:
1890: --If full price book is to be overwritten, then delete the
1891: --corresponding Delta price book

Line 1971: DELETE FROM qp_pb_input_lines

1967:
1968: DELETE FROM qp_pb_input_headers_tl
1969: WHERE pb_input_header_id = l_delta_input_header_id;
1970:
1971: DELETE FROM qp_pb_input_lines
1972: WHERE pb_input_header_id = l_delta_input_header_id;
1973:
1974: END IF; --If Old Delta Request is Not Null or Complete
1975:

Line 2424: FROM qp_pb_input_lines

2420: --Price Book is to be generated
2421:
2422: SELECT * BULK COLLECT
2423: INTO l_pb_input_lines_tbl
2424: FROM qp_pb_input_lines
2425: WHERE pb_input_header_id = p_pb_input_header_id;
2426:
2427: fnd_file.put_line(FND_FILE.LOG, 'Before Insert_Price_Book_Content ');
2428: