APPS.OE_ACKNOWLEDGMENT_PVT dependencies on OE_ORDER_HEADERS

Line 499: FROM oe_order_headers

495: oe_debug_pub.add( 'l_header_rec: packing instructions' ||l_header_rec.packing_instructions ) ;
496: END IF;
497: BEGIN
498: SELECT booked_flag INTO l_booked_flag
499: FROM oe_order_headers
500: WHERE header_id = l_header_rec.header_id;
501:
502: IF l_booked_flag = 'Y' THEN
503: l_header_rec.booked_flag := l_booked_flag;

Line 2080: From oe_order_headers

2076: nvl(l_header_rec.header_id,0) <> 0) Then
2077: Begin
2078: Select booked_flag,xml_message_id
2079: Into l_booked_flag,l_xml_message_id
2080: From oe_order_headers
2081: Where header_id = l_header_rec.header_id;
2082: If l_booked_flag = 'Y' Then
2083: l_header_rec.booked_flag := l_booked_flag;
2084: End If;