APPS.HR_UCX_SHD SQL Statements

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

Line: 49

    select
       ui_context_id
      ,ui_context_key
      ,user_interface_id
      ,label
      ,location
      ,object_version_number
    from        hr_ki_ui_contexts
    where       ui_context_id = p_ui_context_id;

Line: 121

    select
       ui_context_id
      ,ui_context_key
      ,user_interface_id
      ,label
      ,location
      ,object_version_number
    from        hr_ki_ui_contexts
    where       ui_context_id = p_ui_context_id
    for update nowait;

Line: 257

         select user_interface_key
           from hr_ki_user_interfaces
          where  user_interface_id = p_user_interface_id;