The following lines contain the word 'select', 'insert', 'update' or 'delete':
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' ;
select aa.batch_id
from per_absence_attendances aa
where aa.absence_attendance_id = p_absence_attendance_id ;
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;
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;
update per_absence_attendances
set abs_information1 = l_Certificate_required
,abs_information_category = 'AU_' || l_absence_category
where absence_attendance_id = p_creator_id ;
update per_absence_attendances
set abs_information_category = 'AU_' || l_absence_category
,abs_information2 = l_certificate_received
where absence_attendance_id = p_creator_id ;
end insert_absence_dev_desc_flex ;
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' ;
select abs_information_category
from per_absence_attendances
where absence_attendance_id = p_creator_id;
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;
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;
update pay_element_entry_values_f
set screen_entry_value = l_start_date
where element_entry_value_id = l_element_entry_value_id;
update pay_element_entry_values_f
set screen_entry_value = l_end_date
where element_entry_value_id = l_element_entry_value_id;
update pay_element_entry_values_f
set screen_entry_value = l_abs_information1
where element_entry_value_id = l_element_entry_value_id;
update pay_element_entry_values_f
set screen_entry_value = l_abs_information2
where element_entry_value_id = l_element_entry_value_id;
update pay_element_entry_values_f
set screen_entry_value = l_abs_information3
where element_entry_value_id = l_element_entry_value_id;
end update_element_entry_values;