APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_SKILL_PROVISIONS

Line 1448: -- ota_skill_provisions.

1444: -- PUBLIC
1445: -- Description:
1446: -- Delete Validation.
1447: -- This activity version may not be deleted if child rows in
1448: -- ota_skill_provisions.
1449: --
1450: Procedure check_if_tsp_exists
1451: (
1452: p_activity_version_id in number

Line 1460: from ota_skill_provisions tsp

1456: v_proc varchar2(72) := g_package||'check_if_tsp_exists';
1457: --
1458: cursor sel_tsp_exists is
1459: select 'Y'
1460: from ota_skill_provisions tsp
1461: where tsp.activity_version_id = p_activity_version_id;
1462: --
1463: Begin
1464: --