APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_LEARNING_PATH_MEMBERS

Line 1350: -- ota_learning_path_members exist.

1346: -- PUBLIC
1347: -- Description:
1348: -- Delete Validation.
1349: -- This activity version may not be deleted if child rows in
1350: -- ota_learning_path_members exist.
1351: --
1352: Procedure check_if_lpm_exists
1353: (
1354: p_activity_version_id in number

Line 1362: from ota_learning_path_members lpm

1358: v_proc varchar2(72) := g_package||'check_if_lpm_exists';
1359: --
1360: cursor sel_lpm_exists is
1361: select 'Y'
1362: from ota_learning_path_members lpm
1363: where lpm.activity_version_id = p_activity_version_id;
1364: --
1365: Begin
1366: --

Line 2327: ota_learning_path_members lpm

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)
2331: OR (lps.end_date_active IS NOT NULL AND l_start_date > lps.end_date_active));