APPS.PAY_BALANCE_TYPES_DATA_PUMP SQL Statements

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

Line: 13

   select unique_key_id
   into   l_id
   from   hr_pump_batch_line_user_keys
   where  user_key_value = p_user_key_value;

Line: 34

  select balance_category_id
    into l_balance_category_id
     from pay_balance_categories_f
    where category_name = p_category_name
    and nvl(business_group_id, nvl(p_business_group_id,-1))
                         = nvl(p_business_group_id,-1)
    and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))
                        = nvl(hr_api.return_legislation_code(p_business_group_id),' ')
    and p_effective_date between effective_start_date
                                     and effective_end_date;

Line: 67

  select balance_type_id
    into l_balance_type_id
   from pay_balance_types
  where base_balance_type_id is null
    and balance_name = p_base_balance_name
    and nvl(business_group_id, nvl(p_business_group_id,-1))
                         = nvl(p_business_group_id,-1)
    and nvl(legislation_code, nvl(hr_api.return_legislation_code(p_business_group_id),' '))
                        = nvl(hr_api.return_legislation_code(p_business_group_id),' ');

Line: 132

  select blt.object_version_number
    into l_blt_ovn
    from pay_balance_types blt,
         hr_pump_batch_line_user_keys key
   where key.user_key_value  = p_balance_type_user_key
     and blt.balance_type_id = key.unique_key_id;