APPS.PAY_PUT_SHD SQL Statements

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

Line: 27

select legislation_code
from   per_business_groups_perf
where  business_group_id = p_business_group_id;

Line: 142

    select
       user_table_id
      ,business_group_id
      ,legislation_code
      ,range_or_match
      ,user_key_units
      ,user_table_name
      ,user_row_title
      ,object_version_number
    from        pay_user_tables
    where       user_table_id = p_user_table_id;

Line: 215

    select
       user_table_id
      ,business_group_id
      ,legislation_code
      ,range_or_match
      ,user_key_units
      ,user_table_name
      ,user_row_title
      ,object_version_number
    from        pay_user_tables
    where       user_table_id = p_user_table_id
    for update nowait;