DBA Data[Home] [Help]

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;