APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_CERTIFICATION_MEMBERS

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

2439: -- PUBLIC
2440: -- Description:
2441: -- Delete Validation.
2442: -- This activity version may not be deleted if child rows in
2443: -- ota_certification_members exists where this activity version.
2444: --
2445: Procedure check_if_crt_exists
2446: (
2447: p_activity_version_id in number

Line 2456: from ota_certification_members ctm

2452: v_proc varchar2(72) := g_package||'check_if_crt_exists';
2453: --
2454: cursor sel_ctm_exists is
2455: select 'Y'
2456: from ota_certification_members ctm
2457: where ctm.object_id = p_activity_version_id
2458: and ctm.object_type = 'H';
2459: --
2460: Begin

Line 2516: FROM ota_certification_members ctm

2512: l_certification_id NUMBER;
2513:
2514: CURSOR csr_course_crt_dates(l_start_date DATE, l_end_date DATE) IS
2515: SELECT ctm.certification_id
2516: FROM ota_certification_members ctm
2517: WHERE ctm.object_id = p_activity_version_id
2518: AND ctm.object_type='H'
2519: AND (
2520: (l_end_date IS NOT NULL AND ctm.start_date_active > l_end_date)