APPS.PER_OTA_PREDEL_VALIDATION dependencies on OTA_ACTIVITY_VERSIONS

Line 128: or exists( select null from ota_activity_versions

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

Line 140: -- ota_activity_versions

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
142: --
143: hr_utility.set_location('PER_OTA_PREDEL_VALIDATION.ota_predel_org_validation', 10);
144: --

Line 182: from ota_activity_versions

178: IS
179: select null
180: from sys.dual
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

Line 198: -- ota_activity_versions

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: --
202: hr_utility.set_location('PER_OTA_PREDEL_VALIDATION.ota_predel_per_validation', 10);