APPS.OE_BULK_SCHEDULE_UTIL dependencies on OE_ORDER_HEADERS

Line 827: FROM OE_ORDER_HEADERS_ALL

823: --ER#7479609 start
824: BEGIN
825: SELECT order_type_id
826: INTO l_header_rec_for_hold.order_type_id
827: FROM OE_ORDER_HEADERS_ALL
828: WHERE header_id=p_line_rec.header_id(p_line_index);
829: EXCEPTION
830: WHEN OTHERS THEN
831: l_header_rec_for_hold.order_type_id := NULL;

Line 1247: FROM oe_order_headers

1243: IF p_header_id <> nvl(G_HEADER_ID,0) THEN
1244: BEGIN
1245: SELECT order_date_type_code
1246: INTO l_order_date_type_code
1247: FROM oe_order_headers
1248: WHERE header_id = p_header_id;
1249:
1250: G_HEADER_ID := p_header_id;
1251: G_DATE_TYPE := l_order_date_type_code;