APPS.OTA_ENROLL_REVIEW_SS dependencies on OTA_ACTIVITY_VERSIONS

Line 929: l_version_name ota_activity_versions.version_name%type;

925: l_offering_id ota_events.offering_id%type;
926: l_date_booking_placed date;
927: l_current_date date;
928: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
929: l_version_name ota_activity_versions.version_name%type;
930: l_owner_username fnd_user.user_name%type;
931: l_owner_id ota_events.owner_id%type;
932: l_activity_version_id ota_activity_versions.activity_version_id%type;
933: l_event_title ota_events.title%type;

Line 932: l_activity_version_id ota_activity_versions.activity_version_id%type;

928: l_restricted_assignment_id PER_ASSIGNMENTS_F.assignment_id%type;
929: l_version_name ota_activity_versions.version_name%type;
930: l_owner_username fnd_user.user_name%type;
931: l_owner_id ota_events.owner_id%type;
932: l_activity_version_id ota_activity_versions.activity_version_id%type;
933: l_event_title ota_events.title%type;
934: l_course_start_date ota_events.course_start_date%type;
935: l_course_end_date ota_events.course_end_date%type;
936: l_notification_text VARCHAR2(1000);

Line 1017: FROM OTA_ACTIVITY_VERSIONS_TL

1013:
1014: CURSOR csr_activity(p_activity_version_id number )
1015: IS
1016: SELECT version_name
1017: FROM OTA_ACTIVITY_VERSIONS_TL
1018: WHERE activity_version_id = p_activity_version_id
1019: AND language=userenv('LANG');
1020:
1021: