DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on QP_EVENT_PHASES

Line 396: qp_event_phases e

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