[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select global_name,global_value from
ff_globals_f where global_name in ('SUPER_MONTHLY_EARNINGS',
'SUPER_MAX_AGE',
'SUPER_MIN_AGE',
'SUPER_MIN_HOURS',
'SUPER_MAX_BASE_QTR')
and c_effective_date between effective_start_date
and effective_end_date
and legislation_code=c_legislation_code;
select pdb.defined_balance_id
FROM pay_balance_types pbt,
pay_balance_dimensions pbd,
pay_defined_balances pdb
where pbt.balance_name='Super_Guarantee'
AND pbt.legislation_code=c_legislation_code
AND pbd.database_item_suffix = c_dimension_name
AND pbt.balance_type_id = pdb.balance_type_id
AND pbd.balance_dimension_id = pdb.balance_dimension_id;
select /*+ORDERED*/ to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
from pay_assignment_actions paa
, pay_payroll_actions ppa
where paa.assignment_id = c_assignment_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppa.effective_date <= c_effective_date
and ppa.effective_date >= trunc(c_effective_date,'MM')
and ppa.action_type in ('R', 'Q', 'I', 'V', 'B')
and paa.action_status='C'
and ppa.action_status='C'
and paa.tax_unit_id = p_registered_employer;
select /*+ORDERED*/ to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
from pay_assignment_actions paa
, pay_payroll_actions ppa
where paa.assignment_id = c_assignment_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppa.effective_date <= c_effective_date
and ppa.effective_date >= trunc(c_effective_date,'MM')
and ppa.action_type in ('R', 'Q', 'I', 'V', 'B')
and paa.action_status='C'
and ppa.action_status='C'
and paa.tax_unit_id = p_registered_employer;