DBA Data[Home] [Help]

APPS.PV_ENRL_REQUEST_ORDER_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 38: from oe_order_headers_all h

34: BEGIN
35: IF ( p_order_header_id IS NOT NULL ) THEN
36: select h.payment_type_code , h.cust_po_number
37: into v_payment_type_code, v_po_number
38: from oe_order_headers_all h
39: where h.header_id = p_order_header_id;
40:
41: --kvattiku: Aug 05, 05 Directly retrieve from pv_lookups.
42: if(v_payment_type_code is null) then