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 2356: from ota_event_associations

2352: where event_id = p_event_id;
2353: --
2354: cursor get_event_associations is
2355: select null
2356: from ota_event_associations
2357: where event_id = p_event_id;
2358: --
2359: begin
2360: hr_utility.set_location ('Entering:'||l_proc,5);

Line 2821: from ota_event_associations

2817: -- cursor to check if event association exist for the event
2818: --
2819: Cursor c_event_associations_details is
2820: select 'X'
2821: from ota_event_associations
2822: where event_id = p_event_id;
2823: --
2824: -- cursor to check if delegate bookings exist for the event
2825: --