DBA Data[Home] [Help]

APPS.OKE_BILLING_EVENT_PUB dependencies on PA_EVENT_TYPES

Line 454: from PA_EVENT_types WHERE EVENT_TYPE_CLASSIFICATION='MANUAL' and

450: L_Value VARCHAR2(1) := 'N';
451:
452: CURSOR C (p_event_type varchar2) IS
453: SELECT 'X'
454: from PA_EVENT_types WHERE EVENT_TYPE_CLASSIFICATION='MANUAL' and
455: sysdate between start_date_active and nvl(end_date_active,sysdate+1)
456: AND event_type=p_event_type;
457:
458: