APPS.PQH_CRE_SHD SQL Statements

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

Line: 65

    select
       criteria_rate_element_id
      ,criteria_rate_defn_id
      ,element_type_id
      ,input_value_id
      ,business_group_id
      ,legislation_code
      ,object_version_number
    from        pqh_criteria_rate_elements
    where       criteria_rate_element_id = p_criteria_rate_element_id;

Line: 137

    select
       criteria_rate_element_id
      ,criteria_rate_defn_id
      ,element_type_id
      ,input_value_id
      ,business_group_id
      ,legislation_code
      ,object_version_number
    from        pqh_criteria_rate_elements
    where       criteria_rate_element_id = p_criteria_rate_element_id
    for update nowait;