APPS.OTA_TEA_BUS dependencies on OTA_EVENT_ASSOCIATIONS

Line 136: from ota_event_associations

132: --
133: cursor c_get_internal_association is
134: --
135: select 'X'
136: from ota_event_associations
137: where event_id = p_evt_id
138: and (organization_id is not null
139: or position_id is not null
140: or job_id is not null);

Line 144: from ota_event_associations

140: or job_id is not null);
141: --
142: cursor csr_tea is
143: select 1
144: from ota_event_associations
145: where event_id = p_evt_id
146: and customer_id = p_cus_id
147: and (p_tea_id is null or event_association_id <> p_tea_id);
148: --

Line 196: from ota_event_associations

192: l_business_group_id ota_events.business_group_id%type := fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
193: --
194: cursor c_get_customer_association is
195: select 'X'
196: from ota_event_associations
197: where event_id = p_event_id
198: and customer_id is not null;
199: --
200: cursor get_duplicate_tea is

Line 202: from ota_event_associations

198: and customer_id is not null;
199: --
200: cursor get_duplicate_tea is
201: select null
202: from ota_event_associations
203: where event_id = p_event_id
204: and customer_id is null
205: and ((p_organization_id is null and
206: organization_id is null)

Line 485: from ota_event_associations tea

481: from ota_delegate_bookings tdb
482: where tdb.event_id = p_event_id
483: and exists
484: (select null
485: from ota_event_associations tea
486: where tea.event_id = p_event_id
487: and decode(tea.event_association_id,p_event_association_id
488: ,p_customer_id,tea.customer_id) = tdb.customer_id);
489: --

Line 505: from ota_event_associations tea

501: cursor get_associations(l_organization_id number
502: ,l_job_id number
503: ,l_position_id number) is
504: select null
505: from ota_event_associations tea
506: where event_id = p_event_id
507: and event_association_id <> p_event_association_id
508: and nvl(organization_id,-1) = decode(organization_id,null,-1
509: ,nvl(l_organization_id,-1))

Line 573: from ota_event_associations

569: is
570: ---------------
571: cursor csr_combination is
572: select event_id, customer_id
573: from ota_event_associations
574: where event_association_id = p_event_association_id;
575: --
576: l_event_id number;
577: l_customer_id number;

Line 587: fnd_message.set_token('TABLE_NAME','OTA_EVENT_ASSOCIATIONS');

583: l_customer_id;
584: if csr_combination%notfound then
585: fnd_message.set_name('OTA','OTA_13202_GEN_INVALID_KEY');
586: fnd_message.set_token('COLUMN_NAME','EVENT_ASSOCIATION_ID');
587: fnd_message.set_token('TABLE_NAME','OTA_EVENT_ASSOCIATIONS');
588: fnd_message.raise_error;
589: end if;
590: close csr_combination;
591: --