[Home] [Help]
1628:
1629: IS
1630: CURSOR csr_event_associations IS
1631: SELECT ea.organization_id, ea.job_id, ea.position_id
1632: FROM ota_event_associations ea
1633: WHERE ea.event_id = p_event_id;
1634: --
1635:
1636: CURSOR csr_event_start_date IS
1647: NVL( ENROLMENT_END_DATE, TRUNC( SYSDATE)) AND
1648: TRUNC(SYSDATE) <= NVL( COURSE_END_DATE, TRUNC(SYSDATE));
1649: --
1650: CURSOR csr_asg_details
1651: (p_organization_id OTA_EVENT_ASSOCIATIONS.organization_id%TYPE
1652: ,p_job_id OTA_EVENT_ASSOCIATIONS.job_id%TYPE
1653: ,p_position_id OTA_EVENT_ASSOCIATIONS.position_id%TYPE
1654: ,p_course_start_date
1655: otv_scheduled_events.course_start_date%type) IS
1648: TRUNC(SYSDATE) <= NVL( COURSE_END_DATE, TRUNC(SYSDATE));
1649: --
1650: CURSOR csr_asg_details
1651: (p_organization_id OTA_EVENT_ASSOCIATIONS.organization_id%TYPE
1652: ,p_job_id OTA_EVENT_ASSOCIATIONS.job_id%TYPE
1653: ,p_position_id OTA_EVENT_ASSOCIATIONS.position_id%TYPE
1654: ,p_course_start_date
1655: otv_scheduled_events.course_start_date%type) IS
1656: SELECT paf.assignment_id
1649: --
1650: CURSOR csr_asg_details
1651: (p_organization_id OTA_EVENT_ASSOCIATIONS.organization_id%TYPE
1652: ,p_job_id OTA_EVENT_ASSOCIATIONS.job_id%TYPE
1653: ,p_position_id OTA_EVENT_ASSOCIATIONS.position_id%TYPE
1654: ,p_course_start_date
1655: otv_scheduled_events.course_start_date%type) IS
1656: SELECT paf.assignment_id
1657: FROM per_all_assignments_f paf
2074: IS
2075:
2076: CURSOR C_GET_EVT_DETAILS is
2077: SELECT EVT.public_event_flag,EVT.maximum_internal_attendees
2078: from ota_events EVT, ota_event_associations EVA
2079: where EVT.event_id = p_event_id and
2080: EVT.event_id = EVA.event_id and
2081: EVA.customer_id is not null;
2082: