APPS.OTA_TAD_API dependencies on OTA_ACTIVITY_DEFINITIONS_VL

Line 179: from ota_activity_definitions_vl tad

175: v_proc varchar2(72) := g_package||'check_unique_name';
176: --
177: cursor sel_unique_name is
178: select 'Y'
179: from ota_activity_definitions_vl tad
180: where tad.name = p_name
181: and tad.business_group_id = p_business_group_id
182: and (p_activity_id is null or tad.activity_id <> p_activity_id);
183: --

Line 229: from ota_activity_definitions_vl tad

225: v_proc varchar2(72) := g_package||'get_activity_id';
226: --
227: cursor sel_activity_id is
228: select activity_id
229: from ota_activity_definitions_vl tad
230: where tad.name = p_name
231: and tad.business_group_id = p_business_group_id;
232: --
233: Begin