APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_EVENTS

Line 1061: -- ota_events exist.

1057: -- PUBLIC
1058: -- Description:
1059: -- Delete Validation.
1060: -- This activity version may not be deleted if child rows in
1061: -- ota_events exist.
1062: --
1063: Procedure check_if_evt_exists
1064: (
1065: p_activity_version_id in number

Line 1073: from ota_events evt

1069: v_proc varchar2(72) := g_package||'check_if_evt_exists';
1070: --
1071: cursor sel_evt_exists is
1072: select 'Y'
1073: from ota_events evt
1074: where evt.activity_version_id = p_activity_version_id;
1075: --
1076: Begin
1077: --

Line 2143: ota_events evt,

2139: and off.activity_version_id = p_activity_version_id;
2140:
2141: cursor csr_enr is -- For bug 4401602
2142: select 1 from ota_offerings off,
2143: ota_events evt,
2144: ota_delegate_bookings tdb
2145: where evt.parent_offering_id = off.offering_id
2146: and tdb.event_id = evt.event_id
2147: and off.activity_version_id = p_activity_version_id;