APPS.PAY_ARCHIVE dependencies on FF_USER_ENTITIES

Line 33: ff_user_entities item_name lengthened to 240.

29: ff_archive_items
30: nbristow 09-NOV-1999 Changes to the ff_archive_item table made for
31: the new Archive Item API.
32: alogue 15-FEB-2000 Utf8 support : ff_database_items user_name and
33: ff_user_entities item_name lengthened to 240.
34: Use of varchar_240_tbl.
35: Remove insert of 'AAP' into
36: ff_archive_items.archive_type as column doesn't
37: exist in 11i.

Line 141: ff_user_entities UE

137: --
138: cursor csr_defined_balance is
139: select to_number(UE.creator_id)
140: from ff_database_items DI,
141: ff_user_entities UE
142: where DI.user_name = p_db_item_name
143: and UE.user_entity_id = DI.user_entity_id
144: and UE.creator_type = 'B'
145: and (UE.legislation_code = l_legislation_code

Line 245: FROM ff_user_entities ue,

241: us.effective_end_date;
242: --
243: CURSOR contexts_csr (p_user_entity_id VARCHAR2) IS
244: SELECT con.context_name name
245: FROM ff_user_entities ue,
246: ff_route_context_usages rcu,
247: ff_contexts con
248: WHERE ue.user_entity_id = p_user_entity_id AND
249: ue.route_id = rcu.route_id AND

Line 258: creator_type ff_user_entities.creator_type%TYPE;

254: user_entity_id ff_database_items.user_entity_id%TYPE;
255: route_id ff_routes.route_id%TYPE;
256: a_user_entity_id ff_database_items.user_entity_id%TYPE;
257: a_data_type ff_database_items.data_type%TYPE;
258: creator_type ff_user_entities.creator_type%TYPE;
259: name VARCHAR2(240);
260: flag VARCHAR2(1);
261: --
262: BEGIN

Line 287: ff_user_entities ue

283: -- Get archive entity id and data type
284: SELECT dbi.user_entity_id, dbi.data_type
285: INTO a_user_entity_id, a_data_type
286: FROM ff_database_items dbi,
287: ff_user_entities ue
288: WHERE dbi.user_name = db_items_row.item_name AND
289: dbi.user_entity_id = ue.user_entity_id AND
290: ((ue.legislation_code is null
291: and ue.business_group_id is null

Line 294: from ff_user_entities fue2,

290: ((ue.legislation_code is null
291: and ue.business_group_id is null
292: and not exists
293: (select ''
294: from ff_user_entities fue2,
295: ff_database_items fdi2
296: where fdi2.user_name = db_items_row.item_name
297: and fdi2.user_entity_id = fue2.user_entity_id
298: and (fue2.business_group_id = l_business_group_id

Line 306: from ff_user_entities fue2,

302: OR (ue.business_group_id is null
303: and l_legislation_code = ue.legislation_code
304: and not exists
305: (select ''
306: from ff_user_entities fue2,
307: ff_database_items fdi2
308: where fdi2.user_name = db_items_row.item_name
309: and fdi2.user_entity_id = fue2.user_entity_id
310: and fue2.business_group_id = l_business_group_id

Line 322: ff_user_entities ue

318: --
319: SELECT dbi.user_entity_id,ue.creator_type,ue.route_id
320: INTO user_entity_id,creator_type,route_id
321: FROM ff_database_items dbi,
322: ff_user_entities ue
323: WHERE dbi.user_name = name AND
324: dbi.user_entity_id = ue.user_entity_id
325: and ((ue.legislation_code is null
326: and ue.business_group_id is null

Line 329: from ff_user_entities fue2,

325: and ((ue.legislation_code is null
326: and ue.business_group_id is null
327: and not exists
328: (select ''
329: from ff_user_entities fue2,
330: ff_database_items fdi2
331: where fdi2.user_name = name
332: and fdi2.user_entity_id = fue2.user_entity_id
333: and (fue2.business_group_id = l_business_group_id

Line 341: from ff_user_entities fue2,

337: or (ue.business_group_id is null
338: and l_legislation_code = ue.legislation_code
339: and not exists
340: (select ''
341: from ff_user_entities fue2,
342: ff_database_items fdi2
343: where fdi2.user_name = name
344: and fdi2.user_entity_id = fue2.user_entity_id
345: and fue2.business_group_id = l_business_group_id