DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on OE_BLANKET_HEADERS_ALL

Line 805: FROM oe_blanket_headers_all

801: IF p_pb_input_header_rec.price_based_on = 'BSA' THEN
802: BEGIN
803: SELECT order_number
804: INTO l_blanket_number
805: FROM oe_blanket_headers_all
806: WHERE header_id = p_pb_input_header_rec.pl_agr_bsa_id;
807: EXCEPTION
808: WHEN OTHERS THEN
809: l_blanket_number := NULL;

Line 826: FROM oe_blanket_headers_all

822: l_adhoc_lines_tbl(k).attribute := 'QUALIFIER_ATTRIBUTE4';
823: BEGIN
824: SELECT price_list_id
825: INTO l_bsa_hdr_price_list_id
826: FROM oe_blanket_headers_all
827: WHERE header_id = p_pb_input_header_rec.pl_agr_bsa_id;
828: EXCEPTION
829: WHEN OTHERS THEN
830: l_bsa_hdr_price_list_id := null;