APPS.PER_PGT_SHD SQL Statements

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

Line: 48

    select
       hier_node_type_id
      ,business_group_id
      ,hierarchy_type
      ,parent_node_type
      ,child_node_type
      ,child_value_set
      ,object_version_number
      ,identifier_key
    from        per_gen_hier_node_types
    where       hier_node_type_id = p_hier_node_type_id;

Line: 121

    select
       hier_node_type_id
      ,business_group_id
      ,hierarchy_type
      ,parent_node_type
      ,child_node_type
      ,child_value_set
      ,object_version_number
      ,identifier_key
    from        per_gen_hier_node_types
    where       hier_node_type_id = p_hier_node_type_id
    for update nowait;