DBA Data[Home] [Help]

APPS.OTA_EVENT_API dependencies on OTA_EVENTS

Line 18: FROM ota_events

14:
15: CURSOR csr_evt_tz (p_event_id NUMBER)
16: IS
17: SELECT TIMEZONE
18: FROM ota_events
19: WHERE event_id = p_event_id
20: AND event_type IN ('SCHEDULED', 'SELFPACED');
21: BEGIN
22:

Line 64: FROM ota_events

60: p_event_id IN NUMBER
61: )
62: IS
63: SELECT event_id,business_group_id,object_version_number
64: FROM ota_events
65: WHERE parent_event_id = p_event_id;
66: BEGIN
67:
68: for csr_chats_row in csr_chats(p_event_id)