APPS.HR_HNM_SHD SQL Statements

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

Line: 48

    select
       hierarchy_node_map_id
      ,hierarchy_id
      ,topic_id
      ,user_interface_id
      ,object_version_number
    from        hr_ki_hierarchy_node_maps
    where       hierarchy_node_map_id = p_hierarchy_node_map_id;

Line: 118

    select
       hierarchy_node_map_id
      ,hierarchy_id
      ,topic_id
      ,user_interface_id
      ,object_version_number
    from        hr_ki_hierarchy_node_maps
    where       hierarchy_node_map_id = p_hierarchy_node_map_id
    for update nowait;