APPS.OTA_TRNG_ENROLL_SS dependencies on OTV_SCHEDULED_EVENTS

Line 1627: -- FROM otv_scheduled_events

1623: --
1624:
1625: CURSOR csr_event_start_date IS
1626: SELECT course_start_date
1627: -- FROM otv_scheduled_events
1628: FROM ota_events
1629: WHERE event_id = p_event_id and
1630: --Bug#2201434 SELFPACED event_type included.
1631: -- event_type='SCHEDULED' and

Line 1644: otv_scheduled_events.course_start_date%type) IS

1640: (p_organization_id OTA_EVENT_ASSOCIATIONS.organization_id%TYPE
1641: ,p_job_id OTA_EVENT_ASSOCIATIONS.job_id%TYPE
1642: ,p_position_id OTA_EVENT_ASSOCIATIONS.position_id%TYPE
1643: ,p_course_start_date
1644: otv_scheduled_events.course_start_date%type) IS
1645: SELECT a.assignment_id
1646: FROM per_all_assignments_f a
1647: WHERE a.person_id = p_delegate_id
1648: AND NVL(p_course_start_date,trunc(sysdate)) BETWEEN

Line 1659: l_event_start_date otv_scheduled_events.course_start_date%type;

1655: NVL(a.position_id, -1))
1656: AND a.assignment_type = 'E';
1657: --
1658: l_return_value varchar2(4000);
1659: l_event_start_date otv_scheduled_events.course_start_date%type;
1660:
1661: BEGIN
1662: --Bug#2201434 default value of l_return_value modified to '-1' from null.
1663: -- l_return_value := null;