APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_LEARNING_PATH_MEMBERS

Line 1356: -- ota_learning_path_members exist.

1352: -- PUBLIC
1353: -- Description:
1354: -- Delete Validation.
1355: -- This activity version may not be deleted if child rows in
1356: -- ota_learning_path_members exist.
1357: --
1358: Procedure check_if_lpm_exists
1359: (
1360: p_activity_version_id in number

Line 1368: from ota_learning_path_members lpm

1364: v_proc varchar2(72) := g_package||'check_if_lpm_exists';
1365: --
1366: cursor sel_lpm_exists is
1367: select 'Y'
1368: from ota_learning_path_members lpm
1369: where lpm.activity_version_id = p_activity_version_id;
1370: --
1371: Begin
1372: --

Line 2333: ota_learning_path_members lpm

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