APPS.OTA_UTILITY dependencies on OTA_ACTIVITY_VERSIONS

Line 162: ota_activity_versions oav

158: and activity_name = 'OTA_COMPETENCE_NOTIFY_APPROVAL';
159:
160: cursor value_course_level is
161: select oav.competency_update_level from
162: ota_activity_versions oav
163: --, ota_offerings off
164: where oav.activity_version_id = p_obj_id;
165: --and off.offering_id = p_obj_id;
166:

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

Line 2033: FROM ota_activity_versions

2029: l_rco_id number;
2030:
2031: CURSOR get_iln_rco_id IS
2032: SELECT rco_id
2033: FROM ota_activity_versions
2034: WHERE activity_version_id = p_activity_version_id;
2035:
2036:
2037: BEGIN