APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_EVENTS

Line 1067: -- ota_events exist.

1063: -- PUBLIC
1064: -- Description:
1065: -- Delete Validation.
1066: -- This activity version may not be deleted if child rows in
1067: -- ota_events exist.
1068: --
1069: Procedure check_if_evt_exists
1070: (
1071: p_activity_version_id in number

Line 1079: from ota_events evt

1075: v_proc varchar2(72) := g_package||'check_if_evt_exists';
1076: --
1077: cursor sel_evt_exists is
1078: select 'Y'
1079: from ota_events evt
1080: where evt.activity_version_id = p_activity_version_id;
1081: --
1082: Begin
1083: --

Line 2149: ota_events evt,

2145: and off.activity_version_id = p_activity_version_id;
2146:
2147: cursor csr_enr is -- For bug 4401602
2148: select 1 from ota_offerings off,
2149: ota_events evt,
2150: ota_delegate_bookings tdb
2151: where evt.parent_offering_id = off.offering_id
2152: and tdb.event_id = evt.event_id
2153: and off.activity_version_id = p_activity_version_id;