APPS.PAY_SIR_SHD SQL Statements

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

Line: 63

    select
       iterative_rule_id
      ,element_type_id
      ,result_name
      ,iterative_rule_type
      ,input_value_id
      ,severity_level
      ,exclusion_rule_id
      ,object_version_number
    from	pay_shadow_iterative_rules
    where	iterative_rule_id = p_iterative_rule_id;

Line: 136

    select
       iterative_rule_id
      ,element_type_id
      ,result_name
      ,iterative_rule_type
      ,input_value_id
      ,severity_level
      ,exclusion_rule_id
      ,object_version_number
    from	pay_shadow_iterative_rules
    where	iterative_rule_id = p_iterative_rule_id
    for	update nowait;