[Home] [Help]
1617:
1618: IS
1619: CURSOR csr_event_associations IS
1620: SELECT ea.organization_id, ea.job_id, ea.position_id
1621: FROM ota_event_associations ea
1622: WHERE ea.event_id = p_event_id;
1623: --
1624:
1625: CURSOR csr_event_start_date IS
1636: NVL( ENROLMENT_END_DATE, TRUNC( SYSDATE)) AND
1637: TRUNC(SYSDATE) <= NVL( COURSE_END_DATE, TRUNC(SYSDATE));
1638: --
1639: CURSOR csr_asg_details
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
1637: TRUNC(SYSDATE) <= NVL( COURSE_END_DATE, TRUNC(SYSDATE));
1638: --
1639: CURSOR csr_asg_details
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
1638: --
1639: CURSOR csr_asg_details
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
2055: IS
2056:
2057: CURSOR C_GET_EVT_DETAILS is
2058: SELECT EVT.public_event_flag,EVT.maximum_internal_attendees
2059: from ota_events EVT, ota_event_associations EVA
2060: where EVT.event_id = p_event_id and
2061: EVT.event_id = EVA.event_id and
2062: EVA.customer_id is not null;
2063: