APPS.OTA_LEARNER_ENROLL_SS dependencies on OTV_SCHEDULED_EVENTS

Line 1529: -- FROM otv_scheduled_events

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

Line 1546: otv_scheduled_events.course_start_date%type) IS

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

Line 1565: l_event_start_date otv_scheduled_events.course_start_date%type;

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