DBA Data[Home] [Help]

APPS.PAY_PBD_SHD SQL Statements

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

Line: 62

    select
       bal_attribute_default_id
      ,attribute_id
      ,balance_dimension_id
      ,balance_category_id
      ,legislation_code
      ,business_group_id
    from        pay_bal_attribute_defaults
    where       bal_attribute_default_id = p_bal_attribute_default_id;
Line: 124

    select
       bal_attribute_default_id
      ,attribute_id
      ,balance_dimension_id
      ,balance_category_id
      ,legislation_code
      ,business_group_id
    from        pay_bal_attribute_defaults
    where       bal_attribute_default_id = p_bal_attribute_default_id
    for update nowait;