APPS.FF_ARC_SHD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 66

    select
	archive_item_id,
	user_entity_id,
        archive_type,
	context1,
	value,
	object_version_number
    from	ff_archive_items
    where	archive_item_id = p_archive_item_id;

Line: 142

    select 	archive_item_id,
	user_entity_id,
        archive_type,
	context1,
	value,
	object_version_number
    from	ff_archive_items
    where	archive_item_id = p_archive_item_id
    for	update nowait;

Line: 256

 select db.data_type, db.user_name
 from ff_database_items db,
      ff_user_entities ue
 where ue.user_entity_id = c_user_entity_id
 and ue.creator_type = 'X'
 and ue.user_entity_id = db.user_entity_id;