DBA Data[Home] [Help]

APPS.PER_OTA_PREDEL_VALIDATION dependencies on OTA_EVENT_ASSOCIATIONS

Line 20: from ota_event_associations

16: --
17:
18: Cursor CSR_JOB IS
19: Select null
20: from ota_event_associations
21: where job_id = p_job_id;
22:
23: begin
24: --

Line 70: from ota_event_associations

66: l_industry VARCHAR2(1);
67:
68: Cursor CSR_POS IS
69: Select null
70: from ota_event_associations
71: where position_id = p_position_id;
72:
73: begin
74: --

Line 123: from ota_event_associations

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

Line 138: -- ota_event_associations

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
142: --