DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on QP_EVENT_PHASES

Line 397: qp_event_phases e

393: BEGIN
394:
395: SELECT count(*) INTO l_retro_pricing_phase_count
396: FROM qp_pricing_phases p,
397: qp_event_phases e
398: WHERE p.pricing_phase_id=e.pricing_phase_id
399: AND p.pricing_phase_id <> 1
400: AND e.pricing_event_code='RETROBILL'
401: AND trunc(sysdate) BETWEEN trunc(nvl(e.end_date_active,sysdate))