DBA Data[Home] [Help]

APPS.QP_LIMIT_TRANSACTIONS_PVT dependencies on QP_PRICING_PHASES

Line 54: FROM qp_event_phases evt, qp_pricing_phases qpp

50: SELECT t.limit_balance_id, t.list_header_id, t.list_line_id,
51: t.price_request_code, t.pricing_phase_id, t.amount
52: FROM qp_limit_transactions t, qp_npreq_lines_tmp b
53: WHERE t.pricing_phase_id IN (SELECT evt.pricing_phase_id
54: FROM qp_event_phases evt, qp_pricing_phases qpp
55: -- WHERE pricing_event_code = a_pricing_event_code)
56: --fix for bug 4765137
57: WHERE evt.PRICING_PHASE_ID = qpp.PRICING_PHASE_ID
58: AND instr(a_pricing_event_code, evt.pricing_event_code || ',') > 0