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 1523: FROM ota_event_associations ea

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

Line 1542: (p_organization_id OTA_EVENT_ASSOCIATIONS.organization_id%TYPE

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

Line 1543: ,p_job_id OTA_EVENT_ASSOCIATIONS.job_id%TYPE

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

Line 1544: ,p_position_id OTA_EVENT_ASSOCIATIONS.position_id%TYPE

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

Line 1618: from ota_events EVT, ota_event_associations EVA

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