APPS.OTA_TAV_API_BUSINESS_RULES dependencies on OTA_ACTIVITY_DEFINITIONS

Line 315: from ota_activity_definitions tad

311: v_business_group_id number;
312: --
313: cursor get_activity is
314: select business_group_id
315: from ota_activity_definitions tad
316: where activity_id = p_activity_id;
317: --
318: cursor sel_unique_key is
319: select 'Y'

Line 321: , ota_activity_definitions tad

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
325: (p_activity_version_id is not null and

Line 1749: from ota_activity_definitions tad

1745: v_exists varchar2(1);
1746: --
1747: cursor sel_activity is
1748: select 'Y'
1749: from ota_activity_definitions tad
1750: where tad.activity_id = p_activity_id
1751: and tad.multiple_con_versions_flag = 'N' ;
1752: --
1753: Begin

Line 1814: , ota_activity_definitions tad

1810: , tav.start_date
1811: , tav.end_date
1812: , tav.object_version_number
1813: from ota_activity_versions tav
1814: , ota_activity_definitions tad
1815: where tad.activity_id = p_activity_id
1816: and tad.multiple_con_versions_flag = 'N'
1817: and tav.activity_id = tad.activity_id
1818: and tav.start_date =

Line 1888: , ota_activity_definitions tad

1884: --
1885: cursor get_versions is
1886: select tav.end_date
1887: from ota_activity_versions tav
1888: , ota_activity_definitions tad
1889: where tav.activity_id = tad.activity_id --p_activity_id
1890: and tad.activity_id = p_activity_id -- Bug 2808274
1891: and tad.multiple_con_versions_flag = 'N'
1892: order by tav.end_date desc;

Line 1940: from ota_activity_definitions tad

1936: v_proc varchar2(72) := g_package||'check_version_after_supersede';
1937: --
1938: cursor sel_latest_version is
1939: select tav.superseded_by_act_version_id
1940: from ota_activity_definitions tad
1941: , ota_activity_versions tav
1942: where tad.activity_id = p_activity_id
1943: and tad.multiple_con_versions_flag = 'N'
1944: and tav.activity_id = tad.activity_id