968: BEGIN
969:
970: SELECT PRICE_LIST_ID
971: INTO P_PRICE_LIST
972: FROM OE_ORDER_HEADERS_ALL
973: WHERE header_id = (SELECT header_id
974: FROM oe_order_lines_all
975: WHERE line_id = FETCH_INV.INTERFACE_HEADER_ATTRIBUTE6
976: AND org_id = FETCH_INV.org_id);