APPS.PER_OTA_PREDEL_VALIDATION dependencies on OTA_EVENTS

Line 117: from ota_events

113: IS
114: select null
115: from sys.dual
116: where exists(select null
117: from ota_events
118: where organization_id = p_organization_id)
119: or exists(select null
120: from ota_delegate_bookings
121: where organization_id = p_organization_id)

Line 130: or exists( select null from ota_events

126: from ota_finance_headers
127: where organization_id = p_organization_id)
128: or exists( select null from ota_activity_versions
129: where developer_organization_id = p_organization_id)
130: or exists( select null from ota_events
131: where training_center_id = p_organization_id);
132: -- or exists( select null from ota_notrng_histories
133: -- where organization_id = p_organization_id) ;
134: begin

Line 137: -- ota_events

133: -- where organization_id = p_organization_id) ;
134: begin
135: --
136: -- Check there are no values in ota_delegate_bookings
137: -- ota_events
138: -- ota_event_associations
139: -- ota_finance_headers
140: -- ota_activity_versions
141: -- ota_notrng_histories

Line 189: from ota_events

185: from ota_delegate_bookings
186: where delegate_person_id = p_person_id
187: or sponsor_person_id = p_person_id)
188: or exists(select null
189: from ota_events
190: where owner_id = p_person_id)
191: or exists(select null
192: from ota_notrng_histories
193: where person_id = p_person_id and

Line 199: -- ota_events

195: begin
196: --
197: -- Check there are no values in ota_delegate_bookings
198: -- ota_activity_versions
199: -- ota_events
200: -- ota_notrng_histories
201: --
202: hr_utility.set_location('PER_OTA_PREDEL_VALIDATION.ota_predel_per_validation', 10);
203: --