[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pact.action_type
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
order by assact.action_sequence desc;
select pa.payroll_id
, aa.action_sequence
, pa.effective_date
, aa.assignment_id
, pa.business_group_id
, bg.legislation_code
, lrl.rule_mode
from pay_payroll_actions pa
, pay_assignment_actions aa
, per_business_groups bg
, pay_legislation_rules lrl
where aa.assignment_action_id = p_assignment_action_id
and aa.payroll_action_id = pa.payroll_action_id
and pa.business_group_id = bg.business_group_id
and lrl.legislation_code(+) = bg.legislation_code
and lrl.rule_type(+) = 'SAVE_ASG_RUN_BAL';
select ba.defined_balance_id
, bd.dimension_name
, bd.period_type
, bt.balance_name
, bt.reporting_name
, nvl(oi.org_information7,nvl(bt.reporting_name,bt.balance_name)) defined_balance_name
from pay_balance_attributes ba
, pay_bal_attribute_definitions bad
, pay_defined_balances db
, pay_balance_dimensions bd
, pay_balance_types_tl bt
, hr_organization_information oi
where bad.attribute_name = p_balance_attribute
and ( bad.BUSINESS_GROUP_ID IS NULL
OR bad.BUSINESS_GROUP_ID = l_business_group_id)
AND ( bad.LEGISLATION_CODE IS NULL
OR bad.LEGISLATION_CODE = 'GB')
and bad.attribute_id = ba.attribute_id
and ba.defined_balance_id = db.defined_balance_id
and db.balance_dimension_id = bd.balance_dimension_id
and db.balance_type_id = bt.balance_type_id
and bt.language = userenv('LANG')
and oi.org_information1 = 'BALANCE'
and oi.org_information4 = to_char(bt.balance_type_id)
and oi.org_information5 = to_char(db.balance_dimension_id)
and oi.org_information_context = 'Business Group:SOE Detail'
and oi.organization_id = l_business_group_id;
select rb.TAX_UNIT_ID
, rb.JURISDICTION_CODE
, rb.SOURCE_ID
, rb.SOURCE_TEXT
, rb.SOURCE_NUMBER
, rb.SOURCE_TEXT2
from pay_run_balances rb
, pay_assignment_actions aa
, pay_payroll_actions pa
where rb.ASSIGNMENT_ID = l_assignment_id
and l_action_sequence >= aa.action_sequence
and rb.assignment_action_id = aa.assignment_action_id
and aa.payroll_action_id = pa.payroll_action_id
and pa.effective_date >= l_earliest_ctx_date;
select distinct
aa.tax_unit_id tax_unit_id
, rr.jurisdiction_code jurisdiction_code
, decode(l_si_needed_chr,
'Y', pay_balance_pkg.find_context('SOURCE_ID'
,rr.run_result_id)
,null) source_id
, decode(l_st_needed_chr,
'Y', pay_balance_pkg.find_context('SOURCE_TEXT'
,rr.run_result_id)
,null) source_text
, decode(l_sn_needed_chr,
'Y', pay_balance_pkg.find_context('SOURCE_NUMBER'
,rr.run_result_id)
,null) source_number
, decode(l_st2_needed_chr,
'Y', pay_balance_pkg.find_context('SOURCE_TEXT2'
,rr.run_result_id)
,null) source_text2
from pay_assignment_actions aa,
pay_payroll_actions pa,
pay_run_results rr
where aa.ASSIGNMENT_ID = l_assignment_id
and aa.assignment_action_id = rr.assignment_action_id
and l_action_sequence >= aa.action_sequence
and aa.payroll_action_id = pa.payroll_action_id
and pa.effective_date >= l_earliest_ctx_date;
return ('select null COL01 from dual where 1=0');
select ppa.date_earned,
ppa.payroll_action_id,
paa.assignment_id
from pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_action_id = p_assignment_action_id
and paa.payroll_action_id = ppa.payroll_action_id;
select max(org_information8)
from pay_payrolls_f p,
pay_payroll_actions pact,
hr_soft_coding_keyflex flex,
hr_organization_information org
where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
and org.org_information_context = 'Tax Details References'
and org.org_information1 = flex.segment1
and p.business_group_id = org.organization_id
and pact.payroll_action_id = p_payroll_act
and pact.payroll_id = p.payroll_id
and pact.effective_date between p.effective_start_date and p.effective_end_date;
select assignment_id
from per_all_assignments_f
where person_id = p_person_id
and p_effective_date between effective_start_date and effective_end_date;
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,
per_time_periods ptp
where aa.action_status in ('C','S') --Modified for the bug 10066755
--where aa.action_status = 'C'
and pa.payroll_action_id = aa.payroll_action_id
and aa.assignment_id = asg_id
and ptp.payroll_id = pa.payroll_id
and pa.effective_date <= ptp.regular_payment_date
and p_effective_date between ptp.start_date and ptp.end_date
and pa.action_type in ('P','Q','R','U');