[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT global_value
FROM ff_globals_f
WHERE global_name = 'SA_GOSI_BASE_LOWER_LIMIT'
AND legislation_code = 'SA'
AND business_group_id IS NULL
AND l_effective_date BETWEEN effective_start_date
AND effective_end_date;
SELECT global_value
FROM ff_globals_f
WHERE global_name = 'SA_GOSI_BASE_UPPER_LIMIT'
AND legislation_code = 'SA'
AND business_group_id IS NULL
AND l_effective_date BETWEEN effective_start_date
AND effective_end_date;
'SELECT scl.segment2 COL02
,hr_general.decode_lookup(''YES_NO'', scl.segment3) COL03
,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(scl.segment4))
COL04
,hr_general.decode_lookup(''YES_NO'', scl.segment5) COL05
,fnd_date.date_to_displaydate(fnd_date.canonical_to_date(scl.segment6))
COL06 '
|| ' ,TO_CHAR(TO_CHAR(pay_sa_soe.get_reference_salary(:effective_date,
:assignment_action_id)),fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL07
' ||
'FROM per_all_assignments_f asg
,hr_soft_coding_keyflex scl
WHERE asg.assignment_id = :assignment_id
AND :effective_date BETWEEN asg.effective_start_date
AND asg.effective_end_date
AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id';
'Select org.name COL01
,job.name COL02
,loc.location_code COL03
,grd.name COL04
,pay.payroll_name COL05
,pos.name COL06
,hr_general.decode_organization(:tax_unit_id) COL07
,pg.group_name COL08
,peo.national_identifier COL09
,hl.meaning COL10
,asg.assignment_number COL11
,hl1.meaning ||'' ''|| peo.full_name COL12
from per_all_people_f peo
,per_all_assignments_f asg
,hr_all_organization_units_vl org
,per_jobs_vl job
,per_all_positions pos
,hr_locations loc
,per_grades_vl grd
,pay_payrolls_f pay
,pay_people_groups pg
,hr_lookups hl
,hr_lookups hl1
where asg.assignment_id = :assignment_id
and :effective_date
between asg.effective_start_date and asg.effective_end_date
and asg.person_id = peo.person_id
and :effective_date
between peo.effective_start_date and peo.effective_end_date
and asg.position_id = pos.position_id(+)
and asg.job_id = job.job_id(+)
and asg.location_id = loc.location_id(+)
and asg.grade_id = grd.grade_id(+)
and asg.people_group_id = pg.people_group_id(+)
and asg.payroll_id = pay.payroll_id(+)
and :effective_date
between pay.effective_start_date(+) and pay.effective_end_date(+)
and asg.organization_id = org.organization_id
and :effective_date
between org.date_from and nvl(org.date_to, :effective_date)
and hl.application_id (+) = 800
and hl.lookup_type (+) =''NATIONALITY''
and hl.lookup_code (+) =peo.nationality
and hl1.application_id (+) = 800
and hl1.lookup_type (+)=''TITLE''
and hl1.lookup_code (+)=peo.title';
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 '''' || bg.currency_code || '''' currency_code
from pay_payroll_actions pa
, pay_assignment_actions aa
, per_business_groups bg
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 rownum = 1;
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
, pbt.balance_uom
, hl.meaning
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
, pay_balance_types pbt
, hr_lookups hl
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 = l_legislation_code)
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 db.balance_type_id = pbt.balance_type_id
and pbt.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
and hl.lookup_type='UNITS'
and hl.lookup_code = pbt.balance_uom;
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;
SELECT element_type_id
FROM pay_element_types_f
WHERE element_name = 'GOSI'
and legislation_code = 'SA';
SELECT status
FROM pay_run_results rr
WHERE rr.assignment_action_id = p_assignment_action_id
AND rr.element_type_id = l_ele_id;
return ('select null COL01 from dual where 1=0');