DBA Data[Home] [Help]

APPS.PQH_RFE_SHD SQL Statements

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

Line: 70

    select
       rate_factor_on_elmnt_id
      ,criteria_rate_element_id
      ,criteria_rate_factor_id
      ,rate_factor_val_record_tbl
      ,rate_factor_val_record_col
      ,business_group_id
      ,legislation_code
      ,object_version_number
    from        pqh_rate_factor_on_elmnts
    where       rate_factor_on_elmnt_id = p_rate_factor_on_elmnt_id;
Line: 143

    select
       rate_factor_on_elmnt_id
      ,criteria_rate_element_id
      ,criteria_rate_factor_id
      ,rate_factor_val_record_tbl
      ,rate_factor_val_record_col
      ,business_group_id
      ,legislation_code
      ,object_version_number
    from        pqh_rate_factor_on_elmnts
    where       rate_factor_on_elmnt_id = p_rate_factor_on_elmnt_id
    for update nowait;