APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_NOTRNG_HISTORIES

Line 2393: -- ota_notrng_histories exists where this activity version.

2389: -- PUBLIC
2390: -- Description:
2391: -- Delete Validation.
2392: -- This activity version may not be deleted if child rows in
2393: -- ota_notrng_histories exists where this activity version.
2394: --
2395: Procedure check_if_noth_exists
2396: (
2397: p_activity_version_id in number

Line 2406: from ota_notrng_histories nth

2402: v_proc varchar2(72) := g_package||'check_if_noth_exists';
2403: --
2404: cursor sel_noth_exists is
2405: select 'Y'
2406: from ota_notrng_histories nth
2407: where nth.activity_version_id = p_activity_version_id;
2408: --
2409: Begin
2410: --