APPS.OTA_UTILITY dependencies on OTA_ACTIVITY_VERSIONS_TL

Line 337: l_version_name ota_activity_versions_tl.version_name%type; --MLS Change added _tl

333: l_start_date date;
334: l_end_date date;
335: l_full_name ota_customer_contacts_v.full_name%type;
336: l_contact_id hz_cust_account_roles.cust_account_role_id%type;
337: l_version_name ota_activity_versions_tl.version_name%type; --MLS Change added _tl
338:
339:
340: l_max_attendee number(3);
341: l_min_attendee number(3);

Line 367: ota_activity_versions_tl tav -- MLS change _tl added

363: tdb.delegate_contact_id
364: From
365: ota_Delegate_bookings tdb,
366: ota_Events_vl evt, --MLS change _vl added
367: ota_activity_versions_tl tav -- MLS change _tl added
368: Where
369: evt.event_id = tdb.event_id and
370: tdb.line_id = p_line_id and
371: evt.activity_version_id = tav.activity_version_id;

Line 392: ota_activity_versions_tl tav --MLS change _tl added

388: evt.Course_Start_Date,
389: evt.course_End_Date,
390: evt.Maximum_Attendees
391: FROM ota_events_vl evt, -- MLS change _vl added
392: ota_activity_versions_tl tav --MLS change _tl added
393: WHERE evt.line_id = p_line_id and
394: evt.activity_version_id = tav.activity_version_id;
395:
396: cursor c_date_format is