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 758: ota_activity_versions_tl a

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

Line 1863: ota_activity_versions_tl a

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