DBA Data[Home] [Help]

APPS.PAY_BAD_SHD SQL Statements

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

Line: 52

    select
       attribute_id
      ,attribute_name
      ,alterable
      ,legislation_code
      ,business_group_id
      ,user_attribute_name
    from        pay_bal_attribute_definitions
    where       attribute_id = p_attribute_id;
Line: 115

    select
       attribute_id
      ,attribute_name
      ,alterable
      ,legislation_code
      ,business_group_id
      ,user_attribute_name
    from        pay_bal_attribute_definitions
    where       attribute_id = p_attribute_id
    for update nowait;