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_LEARNER_ENROLL_SS dependencies on OTA_EVENT_ASSOCIATIONS

Line 1524: FROM ota_event_associations ea

1520:
1521: IS
1522: CURSOR csr_event_associations IS
1523: SELECT ea.organization_id, ea.job_id, ea.position_id
1524: FROM ota_event_associations ea
1525: WHERE ea.event_id = p_event_id;
1526: --
1527:
1528: CURSOR csr_event_start_date IS

Line 1543: (p_organization_id OTA_EVENT_ASSOCIATIONS.organization_id%TYPE

1539: NVL( ENROLMENT_END_DATE, TRUNC( SYSDATE)) AND
1540: TRUNC(SYSDATE) <= NVL( COURSE_END_DATE, TRUNC(SYSDATE));
1541: --
1542: CURSOR csr_asg_details
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

Line 1544: ,p_job_id OTA_EVENT_ASSOCIATIONS.job_id%TYPE

1540: TRUNC(SYSDATE) <= NVL( COURSE_END_DATE, TRUNC(SYSDATE));
1541: --
1542: CURSOR csr_asg_details
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

Line 1545: ,p_position_id OTA_EVENT_ASSOCIATIONS.position_id%TYPE

1541: --
1542: CURSOR csr_asg_details
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

Line 1619: from ota_events EVT, ota_event_associations EVA

1615: where EVT.event_id = p_event_id;
1616:
1617: CURSOR C_GET_EVT_ACCESS_DETAILS(l_customer_id NUMBER) is
1618: SELECT EVT.public_event_flag,EVT.maximum_internal_attendees
1619: from ota_events EVT, ota_event_associations EVA
1620: where EVT.event_id = p_event_id and
1621: EVT.event_id = EVA.event_id and
1622: EVA.customer_id = l_customer_id;
1623: