APPS.OE_APPROVALS_WF dependencies on OE_BLANKET_HEADERS_EXT

Line 195: from oe_blanket_headers_all obha, oe_blanket_headers_ext obhe

191: where header_id = to_number(itemkey);
192: ELSE
193: select obha.sold_to_org_id, obhe.end_date_active, obha.salesrep_id
194: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
195: from oe_blanket_headers_all obha, oe_blanket_headers_ext obhe
196: where obha.header_id = to_number(itemkey)
197: and obha.order_number = obhe.order_number;
198: END IF;
199:

Line 430: oe_blanket_headers_ext obhe

426:
427: select obha.sold_to_org_id, obhe.end_date_active, obha.salesrep_id
428: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
429: from oe_blanket_headers_all obha,
430: oe_blanket_headers_ext obhe
431: where obha.header_id = l_transaction_id
432: and obha.order_number = obhe.order_number;
433:
434: END IF;