[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
nvl(ppa.date_earned, ppa.effective_date)
from pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_action_id = p_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id;
select
pos.actual_termination_date
from per_periods_of_service pos,
per_assignments_f paf,
pay_assignment_actions paa,
pay_payroll_actions ppa
where paf.assignment_id = paa.assignment_id
and ppa.payroll_action_id = paa.payroll_action_id
and paa.assignment_action_id = p_assignment_action_id
and l_date between paf.effective_start_date
and paf.effective_end_date
and paf.period_of_service_id = pos.period_of_service_id;
select
fnd_number.canonical_to_number(peev.screen_entry_value)
from
pay_element_entries_f pee,
pay_element_entry_values_f peev,
pay_input_values_f piv,
per_pay_bases ppb,
per_assignments_f paf,
pay_payroll_actions ppa,
pay_assignment_actions paa
where
least(nvl(ppa.date_earned, ppa.effective_date),
nvl(l_term_date, nvl(ppa.date_earned, ppa.effective_date)
)
)
between
pee.effective_start_date and pee.effective_end_date
and pee.element_entry_id = peev.element_entry_id
and pee.entry_type = 'E'
and pee.assignment_id = paf.assignment_id
and least(nvl(ppa.date_earned, ppa.effective_date),
nvl(l_term_date, nvl(ppa.date_earned, ppa.effective_date)
)
)
between
peev.effective_start_date and peev.effective_end_date
and peev.input_value_id+0 = piv.input_value_id
and least(nvl(ppa.date_earned, ppa.effective_date),
nvl(l_term_date, nvl(ppa.date_earned, ppa.effective_date)
)
)
between
piv.effective_start_date and piv.effective_end_date
and piv.input_value_id = ppb.input_value_id
and ppb.pay_basis_id = paf.pay_basis_id
and nvl(ppa.date_earned, ppa.effective_date) between
paf.effective_start_date and paf.effective_end_date
and paf.assignment_id = paa.assignment_id
and ppa.payroll_action_id = paa.payroll_action_id
and paa.assignment_action_id = p_assignment_action_id;