[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pee.element_entry_id ee_id,
pee.effective_start_date ee_esd,
pee.effective_end_date ee_eed,
peev1.screen_entry_value applied_mth,
peev2.screen_entry_value new_std_mth_comp
from pay_element_entry_values_f peev2,
pay_element_entry_values_f peev1,
pay_link_input_values_f pliv2,
pay_link_input_values_f pliv1,
pay_element_entries_f pee
where pee.assignment_id = p_assignment_id
and pee.effective_start_date < p_effective_date
and pliv1.element_link_id = pee.element_link_id
and pliv2.element_link_id = pee.element_link_id
and pliv1.input_value_id = p_applied_mth_iv_id
and pliv2.input_value_id = p_new_std_mth_comp_iv_id
and pee.effective_start_date
between pliv1.effective_start_date and pliv1.effective_end_date
and pee.effective_start_date
between pliv2.effective_start_date and pliv2.effective_end_date
and peev1.element_entry_id = pee.element_entry_id
and peev1.input_value_id = pliv1.input_value_id
and peev1.effective_start_date = pee.effective_start_date
and peev1.effective_end_date = pee.effective_end_date
and peev2.element_entry_id = pee.element_entry_id
and peev2.input_value_id = pliv2.input_value_id
and peev2.effective_start_date = pee.effective_start_date
and peev2.effective_end_date = pee.effective_end_date
order by pee.effective_start_date;
select to_number(decode(fg.data_type,'N',fg.global_value,null))
from ff_globals_f fg
where fg.global_id = l_global_id
and p_effective_date
between fg.effective_start_date and fg.effective_end_date;
select min(global_id)
from ff_globals_f fg
where fg.global_name = p_global_name
and nvl(fg.business_group_id,nvl(p_business_group_id,-1)) = nvl(p_business_group_id,-1)
and nvl(fg.legislation_code,nvl(p_legislation_code,'JP')) = nvl(p_legislation_code,'JP');