[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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 pee.effective_start_date
and pee.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_seasonal_shutdown
, abs_information_category = 'NZ_' || l_absence_category
where absence_attendance_id = p_creator_id ;
update per_absence_attendances
set abs_information_category = 'NZ_' || l_absence_category
, abs_information2 = l_number_of_complete_weeks
where absence_attendance_id = p_creator_id ;