[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select assignment_id
from pay_assignment_actions paa
, pay_payroll_actions ppa
where paa.assignment_action_id = c_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppa.action_type in ('R', 'Q', 'I', 'V', 'B');
SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
FROM pay_assignment_actions paa
, pay_payroll_actions ppa
, per_assignments_f paf
, pay_payrolls_f ppf
, per_time_periods ptp
WHERE paf.assignment_id = c_assignment_id
AND paf.assignment_id = paa.assignment_id
AND ppf.payroll_id = ppa.payroll_id
AND ppf.payroll_id = paf.payroll_id
AND ppa.payroll_id = ptp.payroll_id
AND ppf.payroll_id = ptp.payroll_id
AND ptp.time_period_id = ppa.time_period_id
AND ppa.effective_date BETWEEN ptp.start_date
AND ptp.end_date
AND ppa.effective_date BETWEEN paf.effective_start_date
AND paf.effective_end_date
AND ppa.payroll_action_id = paa.payroll_action_id
AND ppa.effective_date <= c_effective_date
AND c_effective_date BETWEEN paf.effective_start_date
AND paf.effective_end_date
AND ppa.action_type IN ('R','Q','I','V','B');
select pdb.defined_balance_id
from pay_defined_balances pdb
, pay_balance_dimensions pbd
where pdb.balance_dimension_id = pbd.balance_dimension_id
and pbd.database_item_suffix = c_db_item_suffix
and pdb.balance_type_id = c_balance_type_id;
select ppa.effective_date
from pay_payroll_actions ppa
, pay_assignment_actions paa
where paa.payroll_action_id = ppa.payroll_action_id
and paa.assignment_action_id = p_assignment_action_id;
SELECT to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
FROM pay_assignment_actions paa
, pay_payroll_actions ppa
, per_assignments_f paf
, pay_payrolls_f ppf
, per_time_periods ptp
WHERE paf.assignment_id = c_assignment_id
AND paf.assignment_id = paa.assignment_id
AND ppf.payroll_id = ppa.payroll_id
AND ppf.payroll_id = paf.payroll_id
AND ppa.payroll_id = ptp.payroll_id
AND ppf.payroll_id = ptp.payroll_id
AND ptp.time_period_id = ppa.time_period_id
AND ppa.effective_date BETWEEN ptp.start_date
AND ptp.end_date
AND ppa.effective_date BETWEEN paf.effective_start_date
AND paf.effective_end_date
AND ppa.payroll_action_id = paa.payroll_action_id
AND ( ppa.effective_date BETWEEN v_ann_start
AND v_ann_end OR
ppa.date_earned BETWEEN v_ann_start
AND v_ann_end)
AND ppa.action_type IN ('R','Q','I','V','B');
SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
FROM pay_assignment_actions paa
, pay_payroll_actions ppa
, per_assignments_f paf
, pay_payrolls_f ppf
, per_time_periods ptp
WHERE paf.assignment_id = c_assignment_id
AND paf.assignment_id = paa.assignment_id
AND ppf.payroll_id = ppa.payroll_id
AND ppf.payroll_id = paf.payroll_id
AND ppa.payroll_id = ptp.payroll_id
AND ppf.payroll_id = ptp.payroll_id
AND ptp.time_period_id = ppa.time_period_id
AND ppa.effective_date BETWEEN ptp.start_date
AND ptp.end_date
AND ppa.effective_date BETWEEN paf.effective_start_date
AND paf.effective_end_date
AND ppa.payroll_action_id = paa.payroll_action_id
AND ( ppa.date_earned <= c_effective_date
or ppa.effective_date <= c_effective_date )
AND c_effective_date BETWEEN paf.effective_start_date
AND paf.effective_end_date
AND ppa.action_type IN ('R','Q','I','V','B');
select ppa.date_earned,ppa.effective_date
from pay_assignment_actions paa,
pay_payroll_actions ppa
where paa.assignment_action_id = c_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppa.action_type in ('R','Q','I','V','B');
SELECT TPERIOD.start_date FROM
pay_payroll_actions PACTION
, per_time_periods TPERIOD
, per_time_period_types TPTYPE
where PACTION.payroll_action_id = (select max(paa.payroll_action_id)
from pay_assignment_actions paa,pay_payroll_actions ppa
where paa.assignment_id=p_assignment_id
and ppa.action_type in ('R','Q')
and ppa.payroll_action_id = paa.payroll_action_id )
and PACTION.payroll_id = TPERIOD.payroll_id
and PACTION.date_earned between TPERIOD.start_date and TPERIOD.end_date
and TPTYPE.period_type = TPERIOD.period_type;
select MIN(ptp.start_date)
from per_time_periods ptp,per_all_assignments_f paa
where ptp.start_date > p_effective_date
and paa.assignment_id = p_assignment_id
and paa.payroll_id = ptp.payroll_id;
select MAX(ptp.end_date)
from per_time_periods ptp,
per_all_assignments_f paa
where ptp.start_date >= add_months(c_effective_date+1,-12)
and ptp.end_date <= c_effective_date
and paa.assignment_id = c_assignment_id
and paa.payroll_id = ptp.payroll_id;
select business_group_id
from per_assignments_f
where assignment_id = p_assignment_id;
select business_group_id
from per_assignments_f
where assignment_id = p_assignment_id;
select ptp.end_date
from per_time_periods ptp
, pay_payroll_actions ppa
, pay_assignment_actions paa
where paa.assignment_action_id = c_assignment_action_id
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.time_period_id = ptp.time_period_id;
select ptp.end_date
from per_time_periods ptp
, pay_payroll_actions ppa
, pay_assignment_actions paa
where paa.assignment_action_id = c_assignment_action_id
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.time_period_id = ptp.time_period_id;
select ptp.end_date
from per_time_periods ptp
, pay_payroll_actions ppa
, pay_assignment_actions paa
where paa.assignment_action_id = c_assignment_action_id
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.time_period_id = ptp.time_period_id;