eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_ENROLL_IN_TRAINING_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 1680: l_event_start_date otv_scheduled_events.course_start_date%type;

1676:
1677:
1678: l_delegate_active number;
1679: l_return_value varchar2(4000);
1680: l_event_start_date otv_scheduled_events.course_start_date%type;
1681:
1682: BEGIN
1683: --Bug#2201434 default value of l_return_value modified to '-1' from null.
1684: -- l_return_value := null;