DBA Data[Home] [Help]

APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_ACTIVITY_VERSIONS_VL

Line 320: from ota_activity_versions_vl tav

316: where activity_id = p_activity_id;
317: --
318: cursor sel_unique_key is
319: select 'Y'
320: from ota_activity_versions_vl tav
321: , ota_activity_definitions tad
322: where tav.version_name = p_version_name
323: and tav.activity_id = tad.activity_id
324: and (p_activity_version_id is null or

Line 560: from ota_activity_versions_vl tav

556: v_proc varchar2(72) := g_package||'get_activity_version_id';
557: --
558: cursor sel_version_id is
559: select activity_version_id
560: from ota_activity_versions_vl tav
561: where tav.activity_id = p_activity_id
562: and tav.version_name = p_version_name;
563:
564: --