APPS.OTA_EL_ENROLL_SS dependencies on OTV_SCHEDULED_EVENTS

Line 1638: -- FROM otv_scheduled_events

1634: --
1635:
1636: CURSOR csr_event_start_date IS
1637: SELECT course_start_date
1638: -- FROM otv_scheduled_events
1639: FROM ota_events
1640: WHERE event_id = p_event_id and
1641: --Bug#2201434 SELFPACED event_type included.
1642: -- event_type='SCHEDULED' and

Line 1655: otv_scheduled_events.course_start_date%type) IS

1651: (p_organization_id OTA_EVENT_ASSOCIATIONS.organization_id%TYPE
1652: ,p_job_id OTA_EVENT_ASSOCIATIONS.job_id%TYPE
1653: ,p_position_id OTA_EVENT_ASSOCIATIONS.position_id%TYPE
1654: ,p_course_start_date
1655: otv_scheduled_events.course_start_date%type) IS
1656: SELECT paf.assignment_id
1657: FROM per_all_assignments_f paf
1658: WHERE paf.person_id = p_delegate_id
1659: AND NVL(p_course_start_date,trunc(sysdate)) BETWEEN

Line 1670: l_event_start_date otv_scheduled_events.course_start_date%type;

1666: NVL(paf.position_id, -1))
1667: AND paf.assignment_type = 'E';
1668: --
1669: l_return_value varchar2(4000);
1670: l_event_start_date otv_scheduled_events.course_start_date%type;
1671:
1672: BEGIN
1673: --Bug#2201434 default value of l_return_value modified to '-1' from null.
1674: -- l_return_value := null;