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