APPS.PER_STC_SHD SQL Statements

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

Line: 55

    select
       component_name
      ,solution_type_name
      ,legislation_code
      ,api_name
      ,parent_component_name
      ,updateable
      ,extensible
      ,object_version_number
    from        per_solution_type_cmpts
    where       component_name = p_component_name
    and   solution_type_name = p_solution_type_name;

Line: 137

    select
       component_name
      ,solution_type_name
      ,legislation_code
      ,api_name
      ,parent_component_name
      ,updateable
      ,extensible
      ,object_version_number
    from        per_solution_type_cmpts
    where       component_name = p_component_name
    and   solution_type_name = p_solution_type_name
    for update nowait;

Line: 221

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

Line: 238

  l_rec.updateable                       := p_updateable;