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 1868: DELETE FROM qp_pb_input_lines

1864:
1865: DELETE FROM qp_pb_input_headers_tl
1866: WHERE pb_input_header_id = l_old_input_header_id;
1867:
1868: DELETE FROM qp_pb_input_lines
1869: WHERE pb_input_header_id = l_old_input_header_id;
1870:
1871: --If full price book is to be overwritten, then delete the
1872: --corresponding Delta price book

Line 1952: DELETE FROM qp_pb_input_lines

1948:
1949: DELETE FROM qp_pb_input_headers_tl
1950: WHERE pb_input_header_id = l_delta_input_header_id;
1951:
1952: DELETE FROM qp_pb_input_lines
1953: WHERE pb_input_header_id = l_delta_input_header_id;
1954:
1955: END IF; --If Old Delta Request is Not Null or Complete
1956:

Line 2403: FROM qp_pb_input_lines

2399: --Price Book is to be generated
2400:
2401: SELECT * BULK COLLECT
2402: INTO l_pb_input_lines_tbl
2403: FROM qp_pb_input_lines
2404: WHERE pb_input_header_id = p_pb_input_header_id;
2405:
2406: fnd_file.put_line(FND_FILE.LOG, 'Before Insert_Price_Book_Content ');
2407: