APPS.HR_AU_ELEMENT_ENTRY_HOOK SQL Statements

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

Line: 29

  procedure insert_absence_dev_desc_flex
  (p_effective_date                 in     date
  ,p_element_entry_id               in     number
  ,p_creator_type                   in     varchar2
  ,p_element_link_id                in     number
  ,p_creator_id                     in     number) is


    l_procedure_name                varchar2(61) := 'hr_au_element_entry_hook.insert_absence_dev_desc_flex' ;

Line: 48

      select aa.batch_id
      from   per_absence_attendances aa
      where  aa.absence_attendance_id = p_absence_attendance_id ;

Line: 58

      select eev.screen_entry_value
      from   pay_input_values_f iv
            ,pay_element_entry_values_f eev
      where  eev.element_entry_id     = p_element_entry_id
      and    p_effective_date   between eev.effective_start_date
                                and     eev.effective_end_date
      and    iv.input_value_id        = eev.input_value_id
      and    iv.name                  = p_input_name
      and    p_effective_date   between iv.effective_start_date
                                and     iv.effective_end_date;

Line: 73

      select paa.absence_category,
             element_name
      from   pay_element_entries_f pee
            ,pay_element_links_f pef
            ,pay_element_types_f pet
            ,pay_input_values_F piv
            ,per_absence_attendance_types paa
      where  pee.element_link_id       = pef.element_link_id
      and    pef.element_type_id       = pet.element_type_id
      and    pet.element_type_id       = piv.element_type_id
      and    paa.input_value_id        = piv.input_value_id
      and    pee.element_link_id       = p_element_link_id
      and    pee.element_entry_id      = p_element_entry_id
      and    p_effective_date    between piv.effective_start_date
                                 and     piv.effective_end_date
      and    p_Effective_date    between pef.effectivE_start_date
                                 and     pef.effective_end_date
      and    p_effective_date    between pet.effective_start_date
                                 and     pet.effective_end_date;

Line: 180

              update per_absence_attendances
              set    abs_information1 = l_Certificate_required
                    ,abs_information_category = 'AU_' || l_absence_category
              where  absence_attendance_id = p_creator_id ;

Line: 208

              update per_absence_attendances
              set    abs_information_category = 'AU_' || l_absence_category
                    ,abs_information2 = l_certificate_received
              where  absence_attendance_id = p_creator_id ;

Line: 220

  end insert_absence_dev_desc_flex ;

Line: 231

procedure update_element_entry_values
  (p_effective_date                 in     date
  ,p_element_entry_id               in     number
  ,p_creator_type                   in     varchar2
  ,p_creator_id                     in     number) is

    l_procedure_name                varchar2(61) := 'hr_au_element_entry_hook.update_element_entry_values' ;

Line: 250

    select abs_information_category
    from per_absence_attendances
    where absence_attendance_id = p_creator_id;

Line: 258

    select to_char(date_start,'YYYY/MM/DD HH24:MI:SS'),to_char(date_end,'YYYY/MM/DD HH24:MI:SS'),abs_information1, abs_information2, abs_information3
    from per_absence_attendances
    where absence_attendance_id = p_creator_id;

Line: 267

   select  peev.element_entry_value_id
   from pay_element_entry_values_f peev,pay_input_values_f piv
   where     peev.element_entry_id = p_element_entry_id
         and piv.name = p_input_name
         and peev.input_value_id = piv.input_value_id;

Line: 305

      update pay_element_entry_values_f
      set screen_entry_value = l_start_date
      where element_entry_value_id = l_element_entry_value_id;

Line: 315

      update pay_element_entry_values_f
      set screen_entry_value = l_end_date
      where element_entry_value_id = l_element_entry_value_id;

Line: 325

      update pay_element_entry_values_f
      set screen_entry_value = l_abs_information1
      where element_entry_value_id = l_element_entry_value_id;

Line: 335

      update pay_element_entry_values_f
      set screen_entry_value = l_abs_information2
      where element_entry_value_id = l_element_entry_value_id;

Line: 345

      update pay_element_entry_values_f
      set screen_entry_value = l_abs_information3
      where element_entry_value_id = l_element_entry_value_id;

Line: 353

end update_element_entry_values;