APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_LEARNING_PATHS_VL

Line 2332: FROM ota_learning_paths_vl lps,

2328: l_learning_path_id NUMBER;
2329:
2330: CURSOR csr_course_lp_dates(l_start_date DATE, l_end_date DATE) IS
2331: SELECT lps.learning_path_id
2332: FROM ota_learning_paths_vl lps,
2333: ota_learning_path_members lpm
2334: WHERE lpm.learning_path_id = lps.learning_path_id
2335: AND lpm.activity_version_id = p_activity_version_id
2336: AND (( l_end_date IS NOT NULL AND lps.start_date_active > l_end_date)