APPS.OE_APPROVALS_WF dependencies on OE_BLANKET_HEADERS_ALL

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 429: from oe_blanket_headers_all obha,

425: ELSE
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:

Line 578: from oe_blanket_headers_all

574: -- If p_sales_document_type_code is not B, it is either a quote or order or line
575: IF nvl(p_sales_document_type_code, 'XXXX') = 'B' THEN
576: select ORDER_TYPE_ID, nvl(TRANSACTION_PHASE_CODE, 'F')
577: into l_transaction_type_id, l_transaction_phase_code
578: from oe_blanket_headers_all
579: where header_id = p_transaction_id;
580: IF l_debug_level > 0 THEN
581: oe_debug_pub.add('Transaction_type_id->' || l_transaction_type_id, 1) ;
582: oe_debug_pub.add('TransactionPhase->' || l_transaction_phase_code, 1);