APPS.OTA_LPS_BUS dependencies on OTA_ACTIVITY_VERSIONS

Line 826: ota_activity_versions tav

822:
823: CURSOR csr_lp_course_dates(l_start_date_active DATE, l_end_date_active DATE)IS
824: SELECT 1
825: FROM ota_learning_path_members lpm,
826: ota_activity_versions tav
827: WHERE tav.activity_version_id = lpm.activity_version_id
828: AND lpm.learning_path_id = p_learning_path_id
829: AND (( tav.end_date IS NOT NULL AND l_start_date_active > tav.end_date)
830: OR (l_end_date_active IS NOT NULL AND tav.start_date > l_end_date_active));