APPS.OTA_DELEGATE_BOOKING_API dependencies on OTA_ACTIVITY_VERSIONS

Line 44: from ota_activity_versions act,ota_Events evt

40: l_eval_mand varchar2(1);
41:
42: Cursor c_sign_info is
43: select act.eres_enabled
44: from ota_activity_versions act,ota_Events evt
45: where act.activity_version_id = evt.activity_version_id
46: and evt.event_id = p_event_id;
47: --
48: l_proc varchar2(72) := g_package||'check_new_status';

Line 161: l_activity_version_id ota_activity_versions.activity_version_id%type;

157: l_event_title ota_events.title%type;
158: l_course_start_date ota_events.course_start_date%type;
159: l_course_end_date ota_events.course_end_date%type;
160: l_owner_id ota_events.owner_id%type;
161: l_activity_version_id ota_activity_versions.activity_version_id%type;
162: l_offering_id ota_events.offering_id%type;
163: l_user number;
164: l_cost_allocation_keyflex_id VARCHAR2(1000);
165: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;

Line 306: from ota_events evt, ota_activity_versions act

302:
303:
304: Cursor csr_sign_info is
305: select act.eres_enabled
306: from ota_events evt, ota_activity_versions act
307: where evt.activity_version_id = act.activity_version_id
308: and evt.event_id=p_event_id;
309:
310: Cursor csr_booking_info is

Line 1308: from ota_activity_versions act,ota_Events evt

1304: and (evt_eval.evaluation_id is not null or act_eval.evaluation_id is not null); --Bug7174996
1305:
1306: Cursor c_sign_info is
1307: select act.eres_enabled
1308: from ota_activity_versions act,ota_Events evt
1309: where act.activity_version_id = evt.activity_version_id
1310: and evt.event_id = p_event_id;
1311:
1312: l_eval_mand varchar2(1);