APPS.CSP_NOTIFICATIONS_ORDER_PKG dependencies on OE_ORDER_HEADERS_ALL
Line 161: FROM oe_order_headers_all
157: ELSE
158: BEGIN
159: SELECT order_number
160: INTO l_order_number 161: FROM oe_order_headers_all 162: WHERE header_id = l_header_rec.order_header_id;
163: EXCEPTION
164: WHEN no_data_found THEN
165: l_order_number := null;
Line 454: FROM oe_order_headers_all
450: ELSE
451: BEGIN
452: SELECT order_number
453: INTO l_order_number 454: FROM oe_order_headers_all 455: WHERE header_id = l_header_rec.order_header_id;
456: EXCEPTION
457: WHEN no_data_found THEN
458: l_order_number := null;