APPS.PER_OTA_PREDEL_VALIDATION dependencies on OTA_NOTRNG_HISTORIES

Line 132: -- or exists( select null from ota_notrng_histories

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
135: --
136: -- Check there are no values in ota_delegate_bookings

Line 141: -- ota_notrng_histories

137: -- ota_events
138: -- ota_event_associations
139: -- ota_finance_headers
140: -- ota_activity_versions
141: -- ota_notrng_histories
142: --
143: hr_utility.set_location('PER_OTA_PREDEL_VALIDATION.ota_predel_org_validation', 10);
144: --
145: --

Line 192: from ota_notrng_histories

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
194: organization_id is not null);
195: begin
196: --

Line 200: -- ota_notrng_histories

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: --
204: -- is ota installed?