eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2814: from ota_program_memberships

2810: -- cursor to check if program membership exist for the event
2811: --
2812: Cursor c_program_membership_details is
2813: select 'X'
2814: from ota_program_memberships
2815: where program_event_id = p_event_id;
2816: --
2817: -- cursor to check if event association exist for the event
2818: --