APPS.PQH_STR_SHD SQL Statements

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

Line: 50

    select
       stat_situation_rule_id
      ,statutory_situation_id
      ,processing_sequence
      ,txn_category_attribute_id
      ,from_value
      ,to_value
      ,enabled_flag
      ,required_flag
      ,exclude_flag
      ,object_version_number
    from        pqh_fr_stat_situation_rules
    where       stat_situation_rule_id = p_stat_situation_rule_id;

Line: 125

    select
       stat_situation_rule_id
      ,statutory_situation_id
      ,processing_sequence
      ,txn_category_attribute_id
      ,from_value
      ,to_value
      ,enabled_flag
      ,required_flag
      ,exclude_flag
      ,object_version_number
    from        pqh_fr_stat_situation_rules
    where       stat_situation_rule_id = p_stat_situation_rule_id
    for update nowait;