APPS.OTA_LEARNER_ENROLL_SS dependencies on OTV_SCHEDULED_EVENTS

Line 1530: -- FROM otv_scheduled_events

1526: --
1527:
1528: CURSOR csr_event_start_date IS
1529: SELECT course_start_date
1530: -- FROM otv_scheduled_events
1531: FROM ota_events
1532: WHERE event_id = p_event_id and
1533: --Bug#2201434 SELFPACED event_type included.
1534: -- event_type='SCHEDULED' and

Line 1547: otv_scheduled_events.course_start_date%type) IS

1543: (p_organization_id OTA_EVENT_ASSOCIATIONS.organization_id%TYPE
1544: ,p_job_id OTA_EVENT_ASSOCIATIONS.job_id%TYPE
1545: ,p_position_id OTA_EVENT_ASSOCIATIONS.position_id%TYPE
1546: ,p_course_start_date
1547: otv_scheduled_events.course_start_date%type) IS
1548: SELECT a.assignment_id
1549: FROM per_all_assignments_f a
1550: WHERE a.person_id = p_delegate_id
1551: --Modified for bug#5032859

Line 1566: l_event_start_date otv_scheduled_events.course_start_date%type;

1562: NVL(a.position_id, -1))
1563: AND a.assignment_type = 'E';
1564: --
1565: l_return_value varchar2(4000);
1566: l_event_start_date otv_scheduled_events.course_start_date%type;
1567:
1568: BEGIN
1569: --Bug#2201434 default value of l_return_value modified to '-1' from null.
1570: -- l_return_value := null;