The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select organization_id, payroll_id
From per_all_assignments_f
Where assignment_id = p_asg_id
and p_effective_date between effective_start_date and effective_end_date;
Select preferential_rate_cd, preferential_rate_rule
from pqh_criteria_rate_defn
Where criteria_rate_defn_id = p_crit_rt_defn_id;
Select organization_id, payroll_id
From per_all_assignments_f
Where assignment_id = p_asg_id
and p_effective_date between effective_start_date and effective_end_date;
Select parent_criteria_rate_defn_id
From pqh_criteria_rate_factors
Where criteria_rate_defn_id = p_crit_rt_defn_id
and business_group_id = p_business_group_id;
Select rate_calc_cd, rate_calc_rule,rounding_cd,rounding_rule,uom,currency_code,reference_period_cd
from pqh_criteria_rate_defn
Where criteria_rate_defn_id = p_crit_rt_defn_id
and business_group_id = p_business_group_id;
select conversion_rate
into l_curr_conv
from gl_daily_rates
where from_currency = l_t_currency_code
and to_currency = l_currency_code
and conversion_date = (select max(conversion_date)
from gl_daily_rates
where from_currency = l_t_currency_code
and to_currency = l_currency_code
and conversion_date <= p_effective_date);
pqh_popl_criteria_ovrrd.insert_criteria_override(p_crit_ovrrd_val_rec => l_crit_val_rec);
Select *
from ben_eligy_criteria
Where (time_entry_access_table_name1 is not null or time_entry_access_table_name2 is not null)
and business_group_id = p_business_group_id;
select a.input_value_id, a.screen_entry_value, b.display_sequence
from pay_element_entry_values_f a, pay_input_values_f b
Where a.element_entry_id = p_element_entry_id
and a.input_value_id = b.input_value_id
order by display_sequence;
Select *
From pay_cost_allocation_keyflex
Where cost_allocation_keyflex_id = p_cost_allocation_keyflex_id;
pqh_popl_criteria_ovrrd.insert_criteria_override(p_crit_ovrrd_val_rec => l_crit_val_rec);
Select *
From pay_element_entries_f
Where element_entry_id = p_element_entry_id
and p_effective_date between effective_start_date and effective_end_date;
Select criteria_rate_defn_id
from pqh_criteria_rate_elements
Where element_type_id = p_element_type_id;
Select *
From per_all_people_f
Where person_id = p_per_id
and p_effective_date between effective_start_date and effective_end_date;
select *
from per_all_assignments_f
Where assignment_id = p_assignment_id
and p_effective_date between effective_start_date and effective_end_date;
Select criteria_rate_defn_id
from pqh_criteria_rate_elements
Where element_type_id = p_element_type_id;
Select *
From per_all_people_f
Where person_id = p_per_id
and p_effective_date between effective_start_date and effective_end_date;
select *
from per_all_assignments_f
Where person_id = p_person_id
and primary_flag = 'Y'
and p_effective_date between effective_start_date and effective_end_date;
select *
from per_all_assignments_f
Where assignment_id = p_assignment_id
and p_effective_date between effective_start_date and effective_end_date;
Select criteria_rate_defn_id
from pqh_criteria_rate_elements
Where element_type_id = p_element_type_id;