[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
nvl(sum(TARGET.result_value * FEED.scale),0)
from
pay_balance_feeds_f FEED,
pay_run_result_values TARGET,
pay_run_results RR,
pay_payroll_actions PACT,
pay_assignment_actions ASSACT,
pay_payroll_actions BACT,
pay_assignment_actions BAL_ASSACT
where BAL_ASSACT.assignment_action_id = assact_id
and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
and FEED.balance_type_id = baltype
and FEED.input_value_id = TARGET.input_value_id
and TARGET.run_result_id = RR.run_result_id
and RR.assignment_action_id = ASSACT.assignment_action_id
and ASSACT.payroll_action_id = PACT.payroll_action_id
and PACT.effective_date between
FEED.effective_start_date and FEED.effective_end_date
and RR.status in ('P','PA')
and PACT.time_period_id = BACT.time_period_id
and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
and ASSACT.assignment_id = BAL_ASSACT.assignment_id;
select
nvl(sum(TARGET.result_value * FEED.scale),0)
from
pay_balance_feeds_f FEED,
pay_run_result_values TARGET,
pay_run_results RR,
pay_payroll_actions PACT,
pay_assignment_actions ASSACT,
pay_payroll_actions BACT,
per_time_periods BPTP,
per_time_periods PPTP,
pay_assignment_actions BAL_ASSACT
where BAL_ASSACT.assignment_action_id = assact_id
and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
and FEED.balance_type_id = baltype
and FEED.input_value_id = TARGET.input_value_id
and TARGET.run_result_id = RR.run_result_id
and RR.assignment_action_id = ASSACT.assignment_action_id
and ASSACT.payroll_action_id = PACT.payroll_action_id
and PACT.effective_date between
FEED.effective_start_date and FEED.effective_end_date
and BACT.time_period_id = BPTP.time_period_id
and PACT.time_period_id = PPTP.time_period_id
and RR.status in ('P','PA')
and PPTP.prd_information1 = BPTP.prd_information1
and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
and ASSACT.assignment_id = BAL_ASSACT.assignment_id;
select
nvl(sum(TARGET.result_value * FEED.scale),0)
from
pay_balance_feeds_f FEED,
pay_run_result_values TARGET,
pay_run_results RR,
pay_payroll_actions PACT,
pay_assignment_actions ASSACT,
pay_payroll_actions BACT,
per_time_periods BPTP,
per_time_periods PPTP,
pay_assignment_actions BAL_ASSACT
where BAL_ASSACT.assignment_action_id = assact_id
and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
and FEED.balance_type_id = baltype
and FEED.input_value_id = TARGET.input_value_id
and TARGET.run_result_id = RR.run_result_id
and RR.assignment_action_id = ASSACT.assignment_action_id
and ASSACT.payroll_action_id = PACT.payroll_action_id
and PACT.effective_date between
FEED.effective_start_date and FEED.effective_end_date
and BACT.time_period_id = BPTP.time_period_id
and PACT.time_period_id = PPTP.time_period_id
and RR.status in ('P','PA')
and PPTP.prd_information1 = BPTP.prd_information1
and PPTP.prd_information2 = BPTP.prd_information2
and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
and ASSACT.assignment_id = BAL_ASSACT.assignment_id;
select
nvl(sum(TARGET.result_value * FEED.scale),0)
from
pay_balance_feeds_f FEED,
pay_run_result_values TARGET,
pay_run_results RR,
pay_payroll_actions PACT,
pay_assignment_actions ASSACT,
pay_payroll_actions BACT,
per_time_periods BPTP,
per_time_periods PPTP,
pay_assignment_actions BAL_ASSACT
where BAL_ASSACT.assignment_action_id = assact_id
and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
and FEED.balance_type_id = baltype
and FEED.input_value_id = TARGET.input_value_id
and TARGET.run_result_id = RR.run_result_id
and RR.assignment_action_id = ASSACT.assignment_action_id
and ASSACT.payroll_action_id = PACT.payroll_action_id
and PACT.effective_date between
FEED.effective_start_date and FEED.effective_end_date
and BACT.time_period_id = BPTP.time_period_id
and PACT.time_period_id = PPTP.time_period_id
and RR.status in ('P','PA')
and PPTP.pay_advice_date = BPTP.pay_advice_date
and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
and ASSACT.assignment_id = BAL_ASSACT.assignment_id;
select
nvl(sum(TARGET.result_value * FEED.scale),0)
from
pay_balance_feeds_f FEED,
pay_run_result_values TARGET,
pay_run_results RR,
pay_payroll_actions PACT,
pay_assignment_actions ASSACT,
pay_payroll_actions BACT,
pay_assignment_actions BAL_ASSACT
where BAL_ASSACT.assignment_action_id = assact_id
and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
and FEED.balance_type_id = baltype
and FEED.input_value_id = TARGET.input_value_id
and TARGET.run_result_id = RR.run_result_id
and RR.assignment_action_id = ASSACT.assignment_action_id
and ASSACT.payroll_action_id = PACT.payroll_action_id
and PACT.effective_date between
FEED.effective_start_date and FEED.effective_end_date
and RR.status in ('P','PA')
and PACT.time_period_id = BACT.time_period_id
and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
and ASSACT.assignment_id = BAL_ASSACT.assignment_id;
select
nvl(sum(TARGET.result_value * FEED.scale),0)
from
pay_balance_feeds_f FEED,
pay_run_result_values TARGET,
pay_run_results RR,
pay_payroll_actions PACT,
pay_assignment_actions ASSACT,
pay_payroll_actions BACT,
per_time_periods BPTP,
per_time_periods PPTP,
pay_assignment_actions BAL_ASSACT
where BAL_ASSACT.assignment_action_id = assact_id
and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
and FEED.balance_type_id = baltype
and FEED.input_value_id = TARGET.input_value_id
and TARGET.run_result_id = RR.run_result_id
and RR.assignment_action_id = ASSACT.assignment_action_id
and ASSACT.payroll_action_id = PACT.payroll_action_id
and PACT.effective_date between
FEED.effective_start_date and FEED.effective_end_date
and BACT.time_period_id = BPTP.time_period_id
and PACT.time_period_id = PPTP.time_period_id
and RR.status in ('P','PA')
and PPTP.prd_information3 = BPTP.prd_information3
and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
and ASSACT.assignment_id = BAL_ASSACT.assignment_id;
select
nvl(sum(TARGET.result_value * FEED.scale),0)
from
pay_balance_feeds_f FEED,
pay_run_result_values TARGET,
pay_run_results RR,
pay_payroll_actions PACT,
pay_assignment_actions ASSACT,
pay_payroll_actions BACT,
per_time_periods BPTP,
per_time_periods PPTP,
pay_assignment_actions BAL_ASSACT
where BAL_ASSACT.assignment_action_id = assact_id
and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
and FEED.balance_type_id = baltype
and FEED.input_value_id = TARGET.input_value_id
and TARGET.run_result_id = RR.run_result_id
and RR.assignment_action_id = ASSACT.assignment_action_id
and ASSACT.payroll_action_id = PACT.payroll_action_id
and PACT.effective_date between
FEED.effective_start_date and FEED.effective_end_date
and BACT.time_period_id = BPTP.time_period_id
and PACT.time_period_id = PPTP.time_period_id
and RR.status in ('P','PA')
and PPTP.pay_advice_date = BPTP.pay_advice_date
and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
and ASSACT.assignment_id = BAL_ASSACT.assignment_id;
select
nvl(sum(TARGET.result_value * FEED.scale),0)
from
pay_balance_feeds_f FEED,
pay_run_result_values TARGET,
pay_run_results RR,
pay_payroll_actions PACT,
pay_assignment_actions ASSACT,
pay_payroll_actions BACT,
pay_assignment_actions BAL_ASSACT
where BAL_ASSACT.assignment_action_id = assact_id
and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
and FEED.balance_type_id = baltype
and FEED.input_value_id = TARGET.input_value_id
and TARGET.run_result_id = RR.run_result_id
and RR.assignment_action_id = ASSACT.assignment_action_id
and ASSACT.payroll_action_id = PACT.payroll_action_id
and PACT.effective_date between
FEED.effective_start_date and FEED.effective_end_date
and RR.status in ('P','PA')
and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
and ASSACT.assignment_id = BAL_ASSACT.assignment_id;
select
nvl(sum(TARGET.result_value * FEED.scale),0)
from
pay_balance_feeds_f FEED,
pay_run_result_values TARGET,
pay_run_results RR,
pay_payroll_actions PACT,
pay_assignment_actions ASSACT
where ASSACT.assignment_action_id = assact_id
and FEED.balance_type_id = baltype
and FEED.input_value_id = TARGET.input_value_id
and TARGET.run_result_id = RR.run_result_id
and RR.assignment_action_id = ASSACT.assignment_action_id
and ASSACT.payroll_action_id = PACT.payroll_action_id
and PACT.effective_date between
FEED.effective_start_date and FEED.effective_end_date
and RR.status in ('P','PA');
select
nvl(sum(TARGET.result_value * FEED.scale),0)
from
pay_balance_feeds_f FEED,
pay_run_result_values TARGET,
pay_run_results RR,
pay_payroll_actions PACT,
pay_assignment_actions ASSACT,
pay_action_interlocks INTLK,
pay_payroll_actions BACT,
pay_assignment_actions BAL_ASSACT
where BAL_ASSACT.assignment_action_id = assact_id
and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
and FEED.balance_type_id = baltype
and FEED.input_value_id = TARGET.input_value_id
and TARGET.run_result_id = RR.run_result_id
and RR.assignment_action_id = ASSACT.assignment_action_id
and ASSACT.payroll_action_id = PACT.payroll_action_id
and PACT.effective_date between
FEED.effective_start_date and FEED.effective_end_date
and RR.status in ('P','PA')
and ASSACT.assignment_action_id = INTLK.locked_action_id
and INTLK.locking_action_id = BAL_ASSACT.assignment_action_id
and BACT.action_type in ('P','U')
and PACT.action_type <> 'V' /* not reversals */
and ASSACT.assignment_id = BAL_ASSACT.assignment_id
and not exists
(select null
from pay_payroll_actions RPACT,
pay_assignment_actions RASSACT,
pay_action_interlocks RINTLK
where ASSACT.assignment_action_id = RINTLK.locked_action_id
and RINTLK.locking_action_id = RASSACT.assignment_action_id
and RPACT.payroll_action_id = RASSACT.payroll_action_id
and RPACT.action_type = 'V');