APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_CERTIFICATION_MEMBERS

Line 2437: -- ota_certification_members exists where this activity version.

2433: -- PUBLIC
2434: -- Description:
2435: -- Delete Validation.
2436: -- This activity version may not be deleted if child rows in
2437: -- ota_certification_members exists where this activity version.
2438: --
2439: Procedure check_if_crt_exists
2440: (
2441: p_activity_version_id in number

Line 2450: from ota_certification_members ctm

2446: v_proc varchar2(72) := g_package||'check_if_crt_exists';
2447: --
2448: cursor sel_ctm_exists is
2449: select 'Y'
2450: from ota_certification_members ctm
2451: where ctm.object_id = p_activity_version_id
2452: and ctm.object_type = 'H';
2453: --
2454: Begin

Line 2510: FROM ota_certification_members ctm

2506: l_certification_id NUMBER;
2507:
2508: CURSOR csr_course_crt_dates(l_start_date DATE, l_end_date DATE) IS
2509: SELECT ctm.certification_id
2510: FROM ota_certification_members ctm
2511: WHERE ctm.object_id = p_activity_version_id
2512: AND ctm.object_type='H'
2513: AND (
2514: (l_end_date IS NOT NULL AND ctm.start_date_active > l_end_date)