APPS.OTA_EVT_BUS dependencies on OTA_PROGRAM_MEMBERSHIPS

Line 371: ota_program_memberships b

367: --
368: cursor c1 is
369: select a.title
370: from ota_events_tl a,
371: ota_program_memberships b
372: where a.event_id = b.program_event_id
373: and b.event_id = p_event_id
374: and a.language = USERENV('LANG');
375: --

Line 545: from ota_program_memberships mem,

541: l_dummy varchar2(1);
542: --
543: cursor c1 is
544: select null
545: from ota_program_memberships mem,
546: ota_events evt
547: where mem.program_event_id = p_event_id
548: and mem.event_id = evt.event_id
549: and evt.event_status = 'P';

Line 2794: from ota_program_memberships

2790: -- cursor to check if program membership exist for the event
2791: --
2792: Cursor c_program_membership_details is
2793: select 'X'
2794: from ota_program_memberships
2795: where program_event_id = p_event_id;
2796: --
2797: -- cursor to check if event association exist for the event
2798: --