APPS.OTA_LPS_BUS dependencies on OTA_LEARNING_PATH_MEMBERS

Line 825: FROM ota_learning_path_members lpm,

821: l_upd_end_date BOOLEAN;
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)