APPS.PER_SLT_SHD SQL Statements

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

Line: 48

    select
       solution_type_name
      ,solution_category
      ,updateable
      ,object_version_number
    from        per_solution_types
    where       solution_type_name = p_solution_type_name;

Line: 117

    select
       solution_type_name
      ,solution_category
      ,updateable
      ,object_version_number
    from        per_solution_types
    where       solution_type_name = p_solution_type_name
    for update nowait;

Line: 181

  ,p_updateable                     in varchar2
  ,p_object_version_number          in number
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 194

  l_rec.updateable                       := p_updateable;