APPS.OE_ADV_PRICE_PVT dependencies on QP_EVENT_PHASES

Line 277: AND PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases

273: SELECT adj.line_id, adj.modified_from,adj.price_adjustment_id
274: FROM OE_PRICE_ADJUSTMENTS adj
275: WHERE HEADER_ID = oe_order_cache.g_header_rec.header_id
276: AND list_line_Type_code = 'IUE'
277: AND PRICING_PHASE_ID IN (select pricing_phase_id from qp_event_phases
278: where instr(p_pricing_events||',', pricing_event_code||',') >0)
279: AND LINE_ID IN (select line_id
280: from qp_preq_lines_tmp where
281: line_type_code='LINE'