APPS.OTA_ADT_BUS dependencies on OTA_ACTIVITY_DEFINITIONS

Line 116: from ota_activity_definitions tad, ota_activity_definitions_tl adt

112: v_proc varchar2(72) := g_package||'check_unique_name';
113: --
114: CURSOR csr_unique_name is
115: select 'Y'
116: from ota_activity_definitions tad, ota_activity_definitions_tl adt
117: --Modified for Bug#3547758
118: -- where upper(adt.name) = upper(p_name)
119: where adt.name = p_name
120: and (tad.business_group_id = p_business_group_id

Line 172: from ota_activity_definitions adt

168: --
169: --Decalare cursor
170: Cursor csr_adtbsg is
171: Select adt.business_group_id
172: from ota_activity_definitions adt
173: where adt.activity_id = Nvl(p_rec.activity_id,p_activity_id) ;
174: --
175: l_business_group_id ota_activity_definitions.business_group_id%TYPE ;
176: --

Line 175: l_business_group_id ota_activity_definitions.business_group_id%TYPE ;

171: Select adt.business_group_id
172: from ota_activity_definitions adt
173: where adt.activity_id = Nvl(p_rec.activity_id,p_activity_id) ;
174: --
175: l_business_group_id ota_activity_definitions.business_group_id%TYPE ;
176: --
177: Begin
178: --
179: hr_utility.set_location('Entering:'||l_proc,5);

Line 214: , ota_activity_definitions tad

210: cursor csr_sec_grp is
211: select pbg.security_group_id,
212: pbg.legislation_code
213: from per_business_groups pbg
214: , ota_activity_definitions tad
215: where tad.activity_id = p_activity_id
216: and pbg.business_group_id = tad.business_group_id;
217: --
218: -- Declare local variables

Line 286: , ota_activity_definitions tad

282: --
283: cursor csr_leg_code is
284: select pbg.legislation_code
285: from per_business_groups pbg
286: , ota_activity_definitions tad
287: where tad.activity_id = p_activity_id
288: and pbg.business_group_id = tad.business_group_id;
289: --
290: -- Declare local variables