[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ppa.date_earned
from pay_payroll_actions ppa,
pay_element_entries_f pee,
pay_assignment_actions paa
where paa.assignment_id=pay_interpreter_pkg.g_asg_id
and paa.payroll_action_id=ppa.payroll_action_id
and ppa.action_type in ('R','Q')
and ppa.date_earned >=pay_interpreter_pkg.g_effective_date
and ppa.date_earned between pee.effective_start_date and pee.effective_end_date
and pee.element_entry_id=pay_interpreter_pkg.g_ee_id
order by ppa.date_earned desc;
select distinct business_group_id
from pay_element_entries_f pee,
per_all_assignments_f paf
where pee.element_entry_id=pay_interpreter_pkg.g_ee_id
and pee.assignment_id=paf.assignment_id
and pay_interpreter_pkg.g_effective_date between
pee.effective_start_date and pee.effective_end_date
and pay_interpreter_pkg.g_effective_date between
paf.effective_start_date and paf.effective_end_date;
select 'Y'
from dual
where exists (
select 'Y'
from pay_element_entries_f pee
,pqh_criteria_rate_elements pcre
,pqh_rate_matrix_rates_f prmr
where pee.element_entry_id=pay_interpreter_pkg.g_ee_id
and pcre.element_type_id=pee.element_type_id
and pcre.criteria_rate_defn_id=prmr.criteria_rate_defn_id
and prmr.rate_matrix_rate_id=pay_interpreter_pkg.g_object_key
and pee.effective_end_date >= prmr.effective_start_date
and pee.effective_start_date <= prmr.effective_end_date)
or exists (
Select 'Y'
from pay_element_entries_f pee,
pqh_criteria_rate_elements pcre,
pqh_criteria_rate_factors pcrf,
pqh_rate_matrix_rates_f prmr
where pee.element_entry_id=pay_interpreter_pkg.g_ee_id
and pcre.element_type_id=pee.element_type_id
and pcre.criteria_rate_defn_id = pcrf.criteria_rate_defn_id
and pcrf.parent_criteria_rate_defn_id = prmr.criteria_rate_defn_id
and prmr.rate_matrix_rate_id = pay_interpreter_pkg.g_object_key
and pee.effective_end_date >= prmr.effective_start_date
and pee.effective_start_date <= prmr.effective_end_date);