DBA Data[Home] [Help]

APPS.PQH_RLA_SHD SQL Statements

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

Line: 53

    select
       rule_attribute_id
      ,rule_set_id
      ,attribute_code
      ,operation_code
      ,attribute_value
      ,object_version_number
    from        pqh_rule_attributes
    where       rule_attribute_id = p_rule_attribute_id;
Line: 124

    select
       rule_attribute_id
      ,rule_set_id
      ,attribute_code
      ,operation_code
      ,attribute_value
      ,object_version_number
    from        pqh_rule_attributes
    where       rule_attribute_id = p_rule_attribute_id
    for update nowait;