DBA Data[Home] [Help]

APPS.PER_SLS_SHD SQL Statements

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

Line: 49

    select
       solution_set_name
      ,user_id
      ,description
      ,status
      ,solution_set_impl_id
      ,object_version_number
    from        per_solution_sets
    where       solution_set_name = p_solution_set_name
    and   user_id = p_user_id;
Line: 125

    select
       solution_set_name
      ,user_id
      ,description
      ,status
      ,solution_set_impl_id
      ,object_version_number
    from        per_solution_sets
    where       solution_set_name = p_solution_set_name
    and   user_id = p_user_id
    for update nowait;