The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT party.party_id as customer_id,
party.party_name as customer_name,
oobha.order_number as blanket_number,
oobhe.end_date_active as expiration_date
FROM oe_blanket_headers_all oobha,
oe_blanket_headers_ext oobhe,
hz_parties party,
hz_cust_accounts_all cust_acct
WHERE oobha.order_number = oobhe.order_number
and oobha.sold_to_org_id = cust_acct.cust_account_id(+)
and cust_acct.party_id = party.party_id(+)
and oobha.sales_document_type_code = 'B'
--and oobha.order_number = c_blanket_number -- < Blanket number>
and oobha.header_id = c_blanket_header_id
and rownum < 2;