APPS.OTA_CPR_BUS dependencies on OTA_ACTIVITY_VERSIONS

Line 304: from OTA_ACTIVITY_VERSIONS oav

300: ) is
301: --
302: cursor get_prereq_crs_end_date is
303: select nvl(end_date, trunc(sysdate))
304: from OTA_ACTIVITY_VERSIONS oav
305: where oav.activity_version_id = p_prerequisite_course_id;
306:
307: l_prereq_crs_end_date OTA_ACTIVITY_VERSIONS.END_DATE%TYPE;
308: l_proc varchar2(72) := g_package||'check_prereq_course_expiry';

Line 307: l_prereq_crs_end_date OTA_ACTIVITY_VERSIONS.END_DATE%TYPE;

303: select nvl(end_date, trunc(sysdate))
304: from OTA_ACTIVITY_VERSIONS oav
305: where oav.activity_version_id = p_prerequisite_course_id;
306:
307: l_prereq_crs_end_date OTA_ACTIVITY_VERSIONS.END_DATE%TYPE;
308: l_proc varchar2(72) := g_package||'check_prereq_course_expiry';
309: --
310: Begin
311: --

Line 356: from OTA_ACTIVITY_VERSIONS oav

352: ) is
353: --
354: cursor get_course_start_date(p_crs_id in number) is
355: select nvl(start_date, trunc(sysdate))
356: from OTA_ACTIVITY_VERSIONS oav
357: where oav.activity_version_id = p_crs_id;
358:
359: l_dest_course_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;
360: l_prereq_course_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;

Line 359: l_dest_course_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;

355: select nvl(start_date, trunc(sysdate))
356: from OTA_ACTIVITY_VERSIONS oav
357: where oav.activity_version_id = p_crs_id;
358:
359: l_dest_course_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;
360: l_prereq_course_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;
361: l_proc varchar2(72) := g_package||'check_course_start_date';
362: --
363: Begin

Line 360: l_prereq_course_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;

356: from OTA_ACTIVITY_VERSIONS oav
357: where oav.activity_version_id = p_crs_id;
358:
359: l_dest_course_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;
360: l_prereq_course_start_date OTA_ACTIVITY_VERSIONS.START_DATE%TYPE;
361: l_proc varchar2(72) := g_package||'check_course_start_date';
362: --
363: Begin
364: --