APPS.HXC_TKGQ_SHD SQL Statements

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

Line: 56

    select
       tk_group_query_id
      ,tk_group_id
      ,group_query_name
      ,include_exclude
      ,system_user
      ,object_version_number
    from	hxc_tk_group_queries tkgq
    where	tkgq.tk_group_query_id = p_tk_group_query_id;

Line: 170

    select
       tk_group_query_id
      ,tk_group_id
      ,group_query_name
      ,include_exclude
      ,system_user
      ,object_version_number
    from	hxc_tk_group_queries tkgq
    where	tkgq.tk_group_query_id = p_tk_group_query_id
    for	update nowait;