[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select regular_payment_date
from per_time_periods
where time_period_id = c_time_period_id;
select min(pac.action_sequence)
from per_assignments_f paf,
per_time_periods ptp,
pay_payroll_actions ppa,
pay_assignment_actions pac
where paf.assignment_id = c_assignment_id
and pac.assignment_id = paf.assignment_id
and ptp.time_period_id = ppa.time_period_id
AND ppa.time_period_id = p_time_period_id
AND ppa.time_period_id = ptp.time_period_id
and ppa.payroll_action_id = pac.payroll_action_id
and ptp.regular_payment_date between paf.effective_Start_date
and paf.effective_end_date
and pac.action_status = 'C'
and ppa.action_status = 'C'
and ptp.regular_payment_date >=
hr_nz_routes.span_start(c_period_payment_date,
1, v_start_of_year_day);
select pac.action_sequence
from pay_payroll_actions ppa,
pay_assignment_actions pac
where ppa.payroll_action_id = pac.payroll_action_id
and ppa.payroll_action_id = c_payroll_action_id
and pac.assignment_id = c_assignment_id;
select sum(prrv.result_value)
from pay_payroll_actions ppa,
pay_assignment_actions pac,
pay_run_results prr,
pay_run_result_values prrv,
pay_element_types_f pet,
pay_input_values_f piv
where ppa.payroll_action_id = c_payroll_action_id
and pac.assignment_id = c_assignment_id
and pet.element_type_id = c_element_type_id
and piv.uom = v_uom
and piv.name = v_input_value_name
and ppa.payroll_action_id = pac.payroll_action_id
and pac.assignment_action_id = prr.assignment_action_id
and prr.run_result_id = prrv.run_result_id
and pet.element_type_id = prr.element_type_id
and pet.element_type_id = piv.element_type_id
and piv.input_value_id = prrv.input_value_id;
SELECT SUM(prrv.result_value)
FROM pay_payroll_actions ppa
, pay_assignment_actions pac
, pay_run_results prr
, pay_run_result_values prrv
, pay_element_types_f pet
, pay_input_values_f piv
WHERE pac.assignment_id = c_assignment_id
AND pet.element_type_id = c_element_type_id
AND piv.uom = v_uom
AND piv.name = v_input_value_name
AND ppa.payroll_action_id = pac.payroll_action_id
AND ppa.time_period_id <= c_time_period_id
AND ppa.payroll_action_id <= c_payroll_action_id
AND pac.assignment_action_id = prr.assignment_action_id
AND prr.run_result_id = prrv.run_result_id
AND pet.element_type_id = prr.element_type_id
AND pet.element_type_id = piv.element_type_id
AND piv.input_value_id = prrv.input_value_id
AND pac.action_sequence >= first_action_sequence(pac.assignment_id, c_time_period_id)
AND pac.action_sequence <= last_action_sequence(c_payroll_action_id, pac.assignment_id);
select time_period_id from pay_payroll_actions
where payroll_action_id = c_payroll_action_id;
select pac.assignment_action_id,
pbf.balance_type_id,
pbf.effective_start_date
from pay_element_types_f pet,
pay_input_values_f piv,
pay_balance_feeds_f pbf,
pay_payroll_actions ppa,
pay_assignment_actions pac,
pay_run_results prr
where ppa.payroll_action_id = c_payroll_action_id
and pet.element_type_id = c_element_type_id
and pac.assignment_id = c_assignment_id
and piv.name = v_input_value_name
and piv.uom = v_uom
and ppa.payroll_action_id = pac.payroll_action_id
and pac.assignment_action_id = prr.assignment_action_id
and pet.element_type_id = piv.element_type_id
and pet.element_type_id = prr.element_type_id
and piv.input_value_id = pbf.input_value_id
and not exists (select null
from pay_balance_feeds_f pbf_not
where pbf_not.balance_feed_id <> pbf.balance_feed_id
and pbf_not.balance_type_id = pbf.balance_type_id
and (ppa.effective_date between pbf_not.effective_start_date
and pbf_not.effective_end_date))
and not exists (select null
from pay_balance_classifications pbc_not
where pbc_not.balance_type_id = pbf.balance_type_id);