DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on OE_BLANKET_HEADERS_ALL

Line 794: FROM oe_blanket_headers_all

790: IF p_pb_input_header_rec.price_based_on = 'BSA' THEN
791: BEGIN
792: SELECT order_number
793: INTO l_blanket_number
794: FROM oe_blanket_headers_all
795: WHERE header_id = p_pb_input_header_rec.pl_agr_bsa_id;
796: EXCEPTION
797: WHEN OTHERS THEN
798: l_blanket_number := NULL;

Line 815: FROM oe_blanket_headers_all

811: l_adhoc_lines_tbl(k).attribute := 'QUALIFIER_ATTRIBUTE4';
812: BEGIN
813: SELECT price_list_id
814: INTO l_bsa_hdr_price_list_id
815: FROM oe_blanket_headers_all
816: WHERE header_id = p_pb_input_header_rec.pl_agr_bsa_id;
817: EXCEPTION
818: WHEN OTHERS THEN
819: l_bsa_hdr_price_list_id := null;