DBA Data[Home] [Help]

APPS.FF_CON_SHD SQL Statements

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

Line: 76

    select
		archive_item_id,
	sequence_no,
	context,
	context_id
    from	ff_archive_item_contexts
    where	archive_item_id = p_archive_item_id
  and   context_id = p_context_id;
Line: 148

    select 	archive_item_id,
	sequence_no,
	context,
	context_id
    from	ff_archive_item_contexts
    where	archive_item_id = p_archive_item_id
  and   context_id = p_context_id
    for	update nowait;