APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_LEARNING_PATHS_VL

Line 2326: FROM ota_learning_paths_vl lps,

2322: l_learning_path_id NUMBER;
2323:
2324: CURSOR csr_course_lp_dates(l_start_date DATE, l_end_date DATE) IS
2325: SELECT lps.learning_path_id
2326: FROM ota_learning_paths_vl lps,
2327: ota_learning_path_members lpm
2328: WHERE lpm.learning_path_id = lps.learning_path_id
2329: AND lpm.activity_version_id = p_activity_version_id
2330: AND (( l_end_date IS NOT NULL AND lps.start_date_active > l_end_date)