APPS.PAY_BALANCE_FEED_DATA_PUMP SQL Statements

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

Line: 38

  select bt.balance_type_id
    into l_balance_type_id
    from pay_balance_types bt, pay_balance_types_tl bttl
   where bt.balance_type_id = bttl.balance_type_id
     and bttl.language = p_language_code
     and bttl.balance_name = p_balance_name
     and (nvl(bt.business_group_id,-1) = p_business_group_id
         or nvl(bt.legislation_code,' ') =
              hr_api.return_legislation_code(p_business_group_id)
         or bt.business_group_id is null
         and bt.legislation_code is null);

Line: 77

   select pbf.object_version_number
     into l_balance_feed_ovn
     from pay_balance_feeds_f pbf,
          hr_pump_batch_line_user_keys key
    where key.user_key_value  = p_balance_feed_user_key
      and pbf.balance_feed_id = key.unique_key_id
      and p_effective_date between pbf.effective_start_date
      and pbf.effective_end_date;