DBA Data[Home] [Help]

APPS.PQH_RMN_SHD SQL Statements

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

Line: 53

    select
       rate_matrix_node_id
      ,short_code
      ,pl_id
      ,level_number
      ,criteria_short_code
      ,node_name
      ,parent_node_id
      ,eligy_prfl_id
      ,business_group_id
      ,legislation_code
      ,object_version_number
    from        pqh_rate_matrix_nodes
    where       rate_matrix_node_id = p_rate_matrix_node_id;
Line: 129

    select
       rate_matrix_node_id
      ,short_code
      ,pl_id
      ,level_number
      ,criteria_short_code
      ,node_name
      ,parent_node_id
      ,eligy_prfl_id
      ,business_group_id
      ,legislation_code
      ,object_version_number
    from        pqh_rate_matrix_nodes
    where       rate_matrix_node_id = p_rate_matrix_node_id
    for update nowait;