APPS.OZF_SPECIAL_PRICING_PVT dependencies on OZF_RESALE_HEADERS
Line 193: FROM ozf_resale_headers a
189: , p_order_number IN VARCHAR2
190: , p_cust_id IN NUMBER
191: , p_date IN DATE ) IS
192: SELECT a.resale_header_id 193: FROM ozf_resale_headers a 194: , ozf_resale_lines_int b
195: , ozf_resale_lines c
196: WHERE b.resale_batch_id = p_id
197: AND b.order_number = p_order_number