APPS.PAY_AU_TAX_INFO_PKG SQL Statements

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

Line: 33

  select element_type_id
  from   pay_element_types_f
  where  element_name = p_element_name
  and    legislation_code = c_legislation_code;

Line: 65

  select input_value_id,
         decode(c_iv_upper,'Y',upper(name),name) iv_name
  from   pay_input_values_f
  where  element_type_id = p_element_type_id
  and    legislation_code = c_legislation_code;

Line: 126

           p_update_mode    out nocopy varchar2,
           p_effective_date out nocopy date,
           p_warning        out nocopy varchar2)
is
--
  l_proc varchar2(80) := c_package||'set_eev_upd_mode';

Line: 133

  l_update_mode varchar2(60);

Line: 141

  select /*+ ORDERED
             USE_NL(PA,PEL,PEE)
             INDEX(PA PER_ASSIGNMENTS_F_PK)
             INDEX(PEL PAY_ELEMENT_LINKS_F_N7)
             INDEX(PEE PAY_ELEMENT_ENTRIES_F_N51) */
         pee.element_entry_id
  from   per_all_assignments_f pa,
         pay_element_links_f pel,
         pay_element_entries_f pee
  where  pa.assignment_id = p_assignment_id
  and    l_effective_date
         between pa.effective_start_date and pa.effective_end_date
  and    pel.element_type_id = g_tax_info_elm_id
  and    l_effective_date
         between pel.effective_start_date and pel.effective_end_date
  and    pel.business_group_id + 0 = pa.business_group_id
  and    pee.assignment_id = pa.assignment_id
  and    pee.element_link_id = pel.element_link_id
  and    pee.effective_start_date > l_effective_date
  and    pee.effective_end_date > l_effective_date;

Line: 207

      l_update_mode := hr_api.g_correction;

Line: 212

      if p_scl_upd_mode = hr_api.g_update_override then
      --
        -- no support hr_api.g_update_override
        -- (use hr_api.g_update_change_insert instead, plus message)
        --
        --l_update_mode := hr_api.g_update_override;

Line: 219

        l_update_mode := hr_api.g_update_change_insert;

Line: 230

        l_update_mode := hr_api.g_update_change_insert;

Line: 241

      l_update_mode := hr_api.g_correction;

Line: 248

      l_update_mode := hr_api.g_update;

Line: 256

    hr_utility.trace('l_update_mode : '||l_update_mode);

Line: 260

  p_update_mode    := l_update_mode;