APPS.OTA_TDB_BUS dependencies on OTA_PROGRAM_MEMBERSHIPS

Line 2123: from ota_program_memberships a

2119: select 'X'
2120: from ota_delegate_bookings
2121: where customer_id = p_customer_id
2122: and event_id in (select a.program_event_id
2123: from ota_program_memberships a
2124: where a.event_id = p_event_id)
2125: and (
2126: (p_booking_id is not null and booking_id <> p_booking_id
2127: )

Line 2141: from ota_program_memberships a

2137: cursor c_organization_parent_booking is
2138: select 'X'
2139: from ota_delegate_bookings
2140: where event_id in (select a.program_event_id
2141: from ota_program_memberships a
2142: where a.event_id = p_event_id)
2143: and (
2144: (p_booking_id is not null and booking_id <> p_booking_id
2145: )

Line 2159: from ota_program_memberships a

2155: -- Check if event is part of a program
2156: --
2157: cursor c_part_of_program is
2158: select null
2159: from ota_program_memberships a
2160: where a.event_id = p_event_id;
2161: --
2162: l_proc varchar2(72) := g_package||'check_programme_member';
2163: l_dummy varchar2(1);

Line 3042: ota_program_memberships pmm

3038:
3039: cursor c_pmm_int_enrollments is
3040: select 1
3041: from ota_delegate_bookings tdb,
3042: ota_program_memberships pmm
3043: where tdb.event_id = pmm.event_id
3044: and pmm.program_event_id = l_event_id
3045: and tdb.delegate_person_id = l_delegate_person_id;
3046:

Line 3050: ota_program_memberships pmm

3046:
3047: cursor c_pmm_ext_enrollments is
3048: select 1
3049: from ota_delegate_bookings tdb,
3050: ota_program_memberships pmm
3051: where tdb.event_id = pmm.event_id
3052: and pmm.program_event_id = l_event_id
3053: and tdb.delegate_contact_id = l_delegate_contact_id;
3054: