APPS.PER_OTA_PREDEL_VALIDATION dependencies on OTA_DELEGATE_BOOKINGS

Line 120: from ota_delegate_bookings

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)
122: or exists(select null
123: from ota_event_associations
124: where organization_id = p_organization_id)

Line 136: -- Check there are no values in ota_delegate_bookings

132: -- or exists( select null from ota_notrng_histories
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

Line 185: from ota_delegate_bookings

181: where exists(select null
182: from ota_activity_versions
183: where controlling_person_id = p_person_id)
184: or exists(select null
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

Line 197: -- Check there are no values in ota_delegate_bookings

193: where person_id = p_person_id and
194: organization_id is not null);
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: --

Line 238: from ota_delegate_bookings

234:
235: Cursor CSR_ASG
236: IS
237: select null
238: from ota_delegate_bookings
239: where delegate_assignment_id = p_assignment_id
240: or sponsor_assignment_id = p_assignment_id ;
241:
242:

Line 245: -- Check there are no values in ota_delegate_bookings

241:
242:
243: begin
244: --
245: -- Check there are no values in ota_delegate_bookings
246: --
247: hr_utility.set_location('PER_OTA_PREDEL_VALIDATION.ota_predel_asg_validation', 10);
248: --
249: --