APPS.OTA_LEARNER_ENROLL_SS dependencies on OTA_ACTIVITY_VERSIONS_TL

Line 130: FROM OTA_ACTIVITY_VERSIONS_TL

126:
127: CURSOR csr_activity(p_activity_version_id number )
128: IS
129: SELECT version_name
130: FROM OTA_ACTIVITY_VERSIONS_TL
131: WHERE activity_version_id = p_activity_version_id
132: AND language=userenv('LANG');
133:
134: CURSOR csr_get_priority IS

Line 759: ota_activity_versions_tl a

755: e.course_start_time,
756: e.course_end_date
757: FROM ota_events_vl e,
758: ota_offerings o,
759: ota_activity_versions_tl a
760: WHERE e.parent_offering_id = o.offering_id
761: AND o.activity_version_id = a.activity_version_id
762: AND e.event_id = p_event_id
763: AND language=userenv('LANG');

Line 1864: ota_activity_versions_tl a

1860: e.course_end_date,
1861: e.owner_id
1862: FROM ota_events_vl e,
1863: ota_offerings o,
1864: ota_activity_versions_tl a
1865: WHERE e.parent_offering_id = o.offering_id
1866: AND o.activity_version_id = a.activity_version_id
1867: AND e.event_id = p_event_id
1868: AND language=userenv('LANG');