[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select effective_date
from fnd_sessions
where session_id = userenv('SESSIONID');
select null
from per_all_assignments_f a1
, per_all_assignments_f a2
where a1.assignment_id = p2_assignment_id
and a2.person_id = a1.person_id
and a2.assignment_id <> a1.assignment_id
and a2.payroll_id is not null
and p_session_date between a2.effective_start_date
and a2.effective_end_date;
select null
from pay_element_types_f et
, pay_input_values_f iv
, pay_run_results rr
, pay_run_result_values rrv
, pay_assignment_actions aa
, pay_payroll_actions pa
, per_time_periods tp
where et.element_name = 'PAYE Tax Deduction'
and iv.element_type_id = et.element_type_id
and iv.name = 'Extra Emol at Low Tax Rate'
and rr.element_type_id = et.element_type_id
and rr.status in ('P','PA')
and rrv.run_result_id = rr.run_result_id
and rrv.input_value_id = iv.input_value_id
and rrv.result_value = 'Y'
and aa.assignment_action_id = rr.assignment_action_id
and aa.assignment_id = p_assignment_id
and pa.payroll_action_id = aa.payroll_action_id
and tp.payroll_id = pa.payroll_id
and pa.date_earned between tp.start_date
and tp.end_date
and tp.regular_payment_date between p_start_date
and p_end_date
and tp.time_period_id = pa.time_period_id
and pa.action_status = 'C'
and aa.action_status = 'C';
select rrv.result_value
from pay_element_types_f et
, pay_input_values_f iv
, pay_run_results rr
, pay_run_result_values rrv
, pay_assignment_actions aa
, per_assignments_f asg
, pay_payroll_actions pa
, per_time_periods tp
where et.element_name = 'Child Support Information'
and iv.element_type_id = et.element_type_id
and iv.name = 'Child Support Code Override'
and rr.element_type_id = et.element_type_id
and rr.status in ('P','PA')
and rrv.run_result_id = rr.run_result_id
and rrv.input_value_id = iv.input_value_id
and rrv.result_value is not null
and aa.assignment_action_id = rr.assignment_action_id
and asg.assignment_id = p_assignment_id
and aa.assignment_id = asg.assignment_id
and pa.payroll_action_id = aa.payroll_action_id
and tp.payroll_id = pa.payroll_id
and pa.date_earned between tp.start_date
and tp.end_date
and pa.effective_date between p_start_date
and p_end_date
and tp.time_period_id = pa.time_period_id
and pa.action_status = 'C'
and aa.action_status = 'C'
order by
pa.action_sequence desc ;
select rrv.result_value
from pay_element_types_f et
, pay_input_values_f iv
, pay_run_results rr
, pay_run_result_values rrv
, pay_assignment_actions aa
, per_assignments_f asg
, pay_payroll_actions pa
, per_time_periods tp
where et.element_name = 'Child Support Deduction'
and iv.element_type_id = et.element_type_id
and iv.name = 'Child Support Code'
and rr.element_type_id = et.element_type_id
and rr.status in ('P','PA')
and rrv.run_result_id = rr.run_result_id
and rrv.input_value_id = iv.input_value_id
and aa.assignment_action_id = rr.assignment_action_id
and asg.assignment_id = p_assignment_id
and aa.assignment_id = asg.assignment_id
and pa.payroll_action_id = aa.payroll_action_id
and tp.payroll_id = pa.payroll_id
and pa.date_earned between tp.start_date
and tp.end_date
and pa.effective_date between p_start_date
and p_end_date
and tp.time_period_id = pa.time_period_id
and pa.action_status = 'C'
and aa.action_status = 'C'
order by pa.action_sequence desc;