[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
rpaa.payroll_action_id,
rpaa.assignment_action_id,
paa.assignment_action_id
from pay_assignment_actions paa,
pay_payroll_actions ppa,
pay_assignment_actions rpaa,
pay_payroll_actions rppa
where paa.payroll_action_id = ppa.payroll_action_id
and rppa.payroll_action_id = rpaa.payroll_action_id
and paa.assignment_action_id =
(select
to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
from pay_payroll_actions pa,
pay_assignment_actions aa
where pa.action_type in ('U','P')
and aa.action_status IN ('C','S') --10225372
and pa.payroll_action_id = aa.payroll_action_id
and aa.assignment_id = p_assignment_id
and pa.effective_date <= p_session_date)
and ppa.action_type in ('P', 'U')
and rpaa.assignment_id = p_assignment_id
and rpaa.action_sequence =
(select max(aa.action_sequence)
from pay_assignment_actions aa,
pay_action_interlocks loc
where loc.locked_action_id = aa.assignment_action_id
and aa.source_action_id is null
and loc.locking_action_id = paa.assignment_action_id); */
select
to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
rpaa.payroll_action_id,
rpaa.assignment_action_id,
paa.assignment_action_id
from pay_assignment_actions paa,
pay_payroll_actions ppa,
pay_assignment_actions rpaa,
pay_payroll_actions rppa
where paa.payroll_action_id = ppa.payroll_action_id
and rppa.payroll_action_id = rpaa.payroll_action_id
and paa.assignment_action_id = curvar2
and ppa.action_type in ('P', 'U')
and rpaa.assignment_id = p_assignment_id
and rpaa.action_sequence =
(select max(aa.action_sequence)
from pay_assignment_actions aa,
pay_action_interlocks loc
where loc.locked_action_id = aa.assignment_action_id
and aa.source_action_id is null
and loc.locking_action_id = paa.assignment_action_id);
select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
paa.assignment_action_id),16))
from pay_assignment_actions paa,
pay_action_interlocks loc
where loc.locked_action_id = paa.assignment_action_id
and paa.source_action_id IS NULL
and loc.locking_action_id = curvar2;
select to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
rpaa.payroll_action_id
from pay_assignment_actions rpaa,
pay_payroll_actions rppa
where rpaa.payroll_action_id = rppa.payroll_action_id
and rpaa.assignment_action_id = curvar3;
select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
from pay_payroll_actions pa,
pay_assignment_actions aa
/*3922415- per_time_periods ptp */
where pa.action_type in ('Q','R','P','U')
and aa.action_status IN ('C','S') --10225372
/*3922415-and ptp.payroll_id = pa.payroll_id*/
and pa.payroll_action_id = aa.payroll_action_id
and aa.assignment_id = p_assignment_id
/*3922415-and pa.effective_date <=ptp.regular_payment_date*/
/*3922415-and p_session_date between ptp.start_date and ptp.end_date;*/
select distinct action_type
from pay_payroll_actions,pay_assignment_actions
where pay_payroll_actions.payroll_action_id = pay_assignment_actions.payroll_action_id
and assignment_action_id =curvar3;
select pac.assignment_action_id
from pay_assignment_actions pac,
pay_run_types_f prt
where pac.run_type_id = prt.run_type_id
-- Added to be driven by index bug 2665701
and pac.assignment_id = p_assignment_id
and pac.source_action_id = p_run_assignment_action_id
and prt.run_method='N';
select pact.action_type , assact.assignment_id
from pay_assignment_actions assact,
pay_payroll_actions pact
where assact.assignment_action_id = p_assignment_action_id
and pact.payroll_action_id = assact.payroll_action_id;
select assact.assignment_action_id
from pay_assignment_actions assact,
pay_action_interlocks loc
where loc.locking_action_id = p_assignment_action_id
and assact.assignment_action_id = loc.locked_action_id
and assact.source_action_id is null
--order by loc.locked_action_id desc ;
select assact.assignment_action_id
from pay_assignment_actions assact,
pay_payroll_actions pact,
pay_action_interlocks loc
where loc.locked_action_id = p_assignment_action_id
and assact.assignment_action_id = loc.locking_action_id
and pact.payroll_action_id = assact.payroll_action_id
and pact.action_type in ('P','U') /* prepayments only */
order by assact.action_sequence desc ;
select pac.assignment_action_id
from pay_assignment_actions pac,
pay_run_types_f prt
where pac.run_type_id = prt.run_type_id
-- Added to be driven by index bug 2665701
and pac.assignment_id = p_assignment_id
and pac.source_action_id = p_run_assignment_action_id
and prt.run_method='N';
select fcu.currency_code
from hr_organization_information hoi,
hr_organization_units hou,
fnd_currencies fcu
where hou.business_group_id = c_business_group_id
and hou.organization_id = hoi.organization_id
and hoi.org_information_context = 'Business Group Information'
and fcu.issuing_territory_code = hoi.org_information9;
select /*+ USE_NL(fcu hoi) */
fcu.currency_code
from hr_organization_information hoi,
fnd_currencies fcu
where hoi.organization_id = c_business_group_id
and hoi.org_information_context = 'Business Group Information'
and fcu.issuing_territory_code = hoi.org_information9;