APPS.OTA_EVT_BUS dependencies on OTA_EVENT_ASSOCIATIONS

Line 416: FROM ota_event_associations

412: AND c.online_flag = 'N';
413:
414: CURSOR evt_associations_cr(l_cust_associations VARCHAR2, l_non_cust_associations VARCHAR2) is
415: SELECT null
416: FROM ota_event_associations
417: WHERE event_id = p_event_id
418: AND (l_cust_associations = 'N' or customer_id is not null)
419: AND (l_non_cust_associations = 'N' or customer_id is null);
420:

Line 802: from ota_event_associations

798: where event_id = p_event_id;
799: --
800: cursor get_tea is
801: select null
802: from ota_event_associations
803: where event_id = p_event_id;
804: begin
805: hr_utility.set_location(' Entering:'||l_proc,10);
806: --

Line 2337: from ota_event_associations

2333: where event_id = p_event_id;
2334: --
2335: cursor get_event_associations is
2336: select null
2337: from ota_event_associations
2338: where event_id = p_event_id;
2339: --
2340: begin
2341: hr_utility.set_location ('Entering:'||l_proc,5);

Line 2801: from ota_event_associations

2797: -- cursor to check if event association exist for the event
2798: --
2799: Cursor c_event_associations_details is
2800: select 'X'
2801: from ota_event_associations
2802: where event_id = p_event_id;
2803: --
2804: -- cursor to check if delegate bookings exist for the event
2805: --